Oracle DBA Training

Reviewing tools and Support Sites

• Introduction to Commonly used Tools : Putty, VNC, Winscp, VPN , telnet . ssh
• Introduction to Online DBA Support Sites : DBALounge Forum , Oracle Support Sites

Oracle Database 11G Architecture

• Instance vs. Oracle Database 11G
• Components of an Oracle Database 11G Instance
• Components of an Oracle Database 11G
• Datafiles, Controlfiles and Redo Logs
• Checkpoints , Roll Forward and Rollback
• Redo log concepts, Instance and Media recovery
• Buffer Cache Block Management - LRU List
• SGA vs. PGA
• Background processes 

Software and Database Installation

• Unix Kernel Parameters Setup
• Important configuration files - sysctl.conf, limits.conf, meminfo ,cpuinfo
• Installation of Oracle Software
• Installation Oracle Database 11G using DBCA
• Setting up of Environment
• Startup and Shutdown of the Oracle Database 11G

Oracle Database 11G Init Parameters

• Init parameters
• Displaying init.ora values with v$parameter
• Sizing SGA components
• Shared pool concepts and components
• Overview of PGA for sorting and pga_aggregate_target
• Alteration of Modifiable and Non Modifiable Init parameters vs. Spfile
• Explaining the use of control files
• File locations for control Files
• Obtaining Control File Information
• Multiplexing Control Files
• Convert Oracle Database 11G to Archivelog Mode
• Archiving the Oracle Redo Logs

Oracle Database 11G Tablespace Management

• Managing Tablespaces - Create, alter, drop, rename, offline, online, read only, read write
• Creating, Resizing, Renaming, offline Datafiles
• Creating and Managing Temporary Tablespaces and Tempfiles
• Creating and Managing Undo Tablespaces
• Understanding Undo Retention
• Free Space / Used Space in Tablespace
• Troubleshooting Undo – snapshot too old
• Online redo log (log_buffer)
• Dictionary queries

Oracle Database 11G Redo Management, Management of Database Segments

• Redo log switch
• Multiplexing the Online Redo Log Files
• Dictionary and v$ views
• The dba_, all_ and user_ structures
• Querying the tables, indexes, and segments views
• Monitoring the alert log
• Oracle Database trace/dump files
• Oracle Database tables : Creation and Maintenance Operations
• Oracle Database Indexes : Creating B*-Tree, bitmap and function-based Indexes
• Oracle Database Views

Oracle Database 11G Reorg, Users, Roles, Profiles, Privileges

• Reorganize Tables
• Index rebuilding
• Creating New Database Users
• Managing Profiles
• Identifying System and Object Privileges
• Granting and Revoking Privileges
• Creating and Modifying Roles
• Displaying user security Information from the Data Dictionary

Oracle Database 11G*Net configuration

• Understanding the Listener and how connection takes place from Client to Server
• Use Netca
• Creating the listener.ora file
• Creating the tnsnames.ora file
• Verifying network connectivity with ping and tnsping
• Testing Oracle Database 11G connection via Listener

Oracle Database 11G Backup & Recovery

• Hot vs. Cold backups
• Backup in Archivelog vs. Noarchivelog Mode
• Taking Cold Backups
• Taking Hot Backups
• Concepts of Hot Backup
• Complete and Incomplete Recovery
• Restoration from cold Backup with complete data loss
• Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces
• Loss of Controlfiles
• Loss of Redo Logs - Inactive and Active
• Complete and Incomplete Recovery

Oracle Database 11G Backup and Recovery management using RMAN

• Advantages of RMAN
• Advantages of Catalog over Nocatalog
• Catalog Creation
• RMAN Closed Database and Hot Backups
• RMAN Backup Management (Backup Database , tablespace , Datafile ,controlfile ,archivelogs , spfile)
• Viewing Backups using List
• Configure RMAN(Configure channels , autobackup , tape / disk ,retention Policies)
• Reporting Backups
• Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces
• Loss of Controlfiles
• Loss of Redo Logs - Inactive and Active
• Complete and Incomplete Recovery

Oracle Database 11G DBA Utilities

• Imp and exp utilities
• Data pump (impdp and expdp)

Oracle Database 11G DBA Utilities

• DBVerify for Corruptions
• Flashback Oracle Database, Flashback Drop , Flashback Query
• Using Opatch for Oracle Database Patching

Cloning Of Oracle Database

• Cloning using Hot Backup
• Cloning Using RMAN Duplicate Database

Performance Management : Understand Problem, Check OS and Automated Reports

• Understand the Performance Problem Scope
• Discuss with the affected Users
• Check dynamic performance views useful in tuning
• Use dynamic performance views to view statistics and wait events
• Create and manage AWR snapshots
• Generate AWR reports
• Generate ADDM reports
• Log a performance Service Request with Oracle Support

Performance Management : Tuning the Oracle Database 11G Instance

• Tuning SGA
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Checkpoint and Redo Tuning
• Diagnose checkpoint and redo issues
• Size the redo log file
• Size the redo log buffer
• Diagnose PGA memory issues
• Size the PGA memory
• Diagnose temporary space issues
• Understanding Locks
• Detect enqueue contention

Oracle Database 11G Performance Management : DBMS_STATS, Detect Fragmentation, SQL Tuning

• Cost Based Optimizer
• Using EXPLAIN PLAN
• Using “set autotrace”
• Interpreting EXPLAIN PLAN Output
• Collecting Schema , table and index statistics (dbms_stats)
• Checking Statistics
• Tracing a Database Session
• Using TKPROF to analyze a trace File

Oracle Database 11G Maintenance & Job Scheduling and Processes

• Monitoring Systems
• Commonly configured Oracle Database Alerts and Actions to be taken
• Common Monitoring Problems Encountered and Resolution
• Change Management Process , Approval Process
• Ticket Management Process (Severity , Priority , SLAs,Communication Protocol)