oracle

oracle

Oracle DBA Concepts

Oracle10g Instance creation and management

  • What is an Oracle Instance?
  • Installing Oracle
  • Oracle Optimal Flexible Architecture (OFA)
    • Locating initialization, listener.ora & sqlnet.ora files
    • Finding the alert log
  • Common environment variables
  • Structures in an Oracle Instance
  • Oracle Memory Structures, SGA and PGA
  • Oracle Processes and their purposes
  • Startup nomount, mount and open database commands
  • Sample Oracle10g OCP exam questions

Oracle10g Database Architecture

  • Oraclde10g management framework
  • Using the Database Creation Assistant (DBA)
  • Creating and dropping a database
  • Tablespaces
  • Tables and Indexes
  • Clusters
  • Partitioning of Tables and Indexes
  • Gathering and applying patches
  • Sample Oracle10g OCP exam questions

Concurrency Management

  • Transactions, serialization, locks and latches
  • Lock modes
  • Detecting and resolving lock conflicts
  • Managing deadlocks

Interfacing with Oracle

  • Oracle transaction management
  • Using SQL*Plus and iSQL*Plus
  • Using embedded Oracle with Pro*C & Java
  • PL/SQL & Triggers
  • Pining PL/SQL packages & compiling PL/SQL
  • System-level triggers – startup trigger, logon trigger, PL/SQL error trigger

Oracle*Net

  • Basic Network structure
  • Oracle*Net Files
  • Multi-threaded server
  • Create additional listeners
  • Create Oracle Net service aliases
  • Configure connect time failover
  • Use ping and tnsping
  • Oracle*Net names resolution
  • Sample Oracle10g OCP exam questions

 

DBA Management

Tablespace Management Overview

  • Dictionary Managed Tablespaces
  • Locally Managed Tablespaces
  • Automatic Segment Space Management
  • Moving tablespaces online and offline
  • Sample Oracle10g OCP exam questions

UNDO Tablespace Management

  • Use of undo segments
  • Creating an undo tablespace
  • User managed undo tablespaces
  • Automatic undo management
  • Monitor & Configure undo retention
  • Use the Undo Advisor
  • Size the undo tablespace
  • Sample Oracle10g OCP exam questions

Oracle Utilities

  • Datapump - Import/export
  • SQL*Loader
  • Oracle streams

 

Oracle Performance Tuning

  • Locate invalid and unusable objects
  • Gather SQL optimizer statistics with dbms_stats
  • Basic Oracle performance metrics
  • Use OEM and dbms_alert to set warning and critical alert thresholds
  • The SQL Tuning Advisor
  • The SQL Access Advisor
  • Interpreting server generated alerts
  • Oracle advisory utilities v$db_cache_advice, v$shared_pool_advice, v$pga_aggregate_target_advice
  • Using OEM performance screens
  • Fixing performance issues

 

Oracle security and user management

User Management

  • Creating Users
  • Altering users
  • User Profiles
  • User resource groups
  • Granting privileges & roles
  • Auditing user activity with dbms_audit
  • Sample Oracle10g OCP exam questions

Oracle Security

  • Password use in Oracle
    • Password encryption and password aging
    • External authentication
    • Using Single sign-on (SSO)
  • Object security
  • Virtual Private Databases (VPD) in Oracle
  • Oracle “grant execute” security
  • Use of Roles in Oracle
  • Register for security updates
  • Sample Oracle10g OCP exam questions

Backup & Recovery

  • Oracle backup & recovery planning
  • Parallel instance recovery
  • Basics of checkpoints, redo log files, and archived log files
  • Using ARCHIVELOG mode
  • Creating consistent Oracle backups
  • Online hot backups
  • Incremental Oracle backups
  • Automating database backups with dbms_scheduler
  • Monitor the flash recovery area
  • Recovering from loss of a Control file
  • Recovering from loss of a Redo log file
  • Recovering from loss of a system-critical data file
  • Recovering from loss of a non system-critical data file