About us   Registration   Site map    
 
         
   
      New user|Forgot password  
 
   
 
 
Select Your Country to check the Schedule for this Course
Country:  
Time Zone:
   
PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT
Course Name Course Code
Advanced Oracle DBA 64
Course Contents

Advanced Oracle DBA

 

OCFS

- Installation & configuration

- Administering OCFS (start & stop cluster, mounting/dismouting volumes, tuning)

- Sing Context Dependent Symbolic Links - CDSL

- Debugging OCFS

- Sample troubleshooting

 

ASM

- Installation

- Creating & configuring ASM instance

- Asm storage internals & metadata

- Administering ASM disks & diskgroups

- Redundancy & failure Groups

- Rebalance & redistribution

- Using asmcmd

 

RAC Installation and Administration

- Installing clusterware - (os preparation, configuring SSH/RSH/RCP etc)

- Voting disk & OCR concepts & administration

- add/delete clusterware homes

- Creating RAC Database.

- Administration of RAC Database.

- Cache fusion, instance locking and serialization internals

- Using crsctl, cluvfy, olsnodes, oifcfg, ocrconfig

- Monitoring & troubleshooting oracle clusterware

- Backup and Recovery on RAC Database.

 

Dataguard

- Creating a Physical Standby database.

- Redo transport services - confiure, monitor, tune & troubleshoot

- Redo apply services - confiure, monitor, troubleshoot

- Database Role transition - Failover and switch over.

- Troubleshooting

- Offloading backups to standby site.

- Opening standby for reporting.

 

Advanced SQL Tuning

- Library cache internals & sql parsing

- Using explain plan & dbms_xplan

- Using v$sql* views

- Using 10046 & 10053 traces

- Interpreting execution plans

- Histograms

- Using hints

- Tuning joins

- Using plan stability

- Tuning & monitoring parallel sql

- Real application testing

- Using sql access advisor

- Using sql tuning advisor

- Using sql plan management

 

Advanced Instance Tuning

- Wait events, system & session statistics.

- AWR, ASH & ADDM. generating custom reports from AWR

- Monitor & tune Shared Pool/Large Pool. monitor multiple sub pools in the shared pool

- Monitor & tune buffer cache - monitoring cache buffer latch contention

- Monitor & tune PGA

- Configure, monitor & tune client result cache

- io monitoring & configuration. IO calibration. using ORION

- Monitoring OS

- v$views

PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT