ADVANCED DBA
Oracle9i Real Application Clusters


Regular Track - 3 Days
 
Global resource directory reconfiguration & cache recovery

  1. High availability design considerations

  2. Change management

  3. Configuring redundant hardware

  4. Primary & secondary instances

  5. Spare nodes

  6. Parameters for high avaibility

  7. Oracle9i for dataguard

  8. Standby database real application clusters support

  9. Log transport services : Standby database setup

  10. Log transport services : Primary database setup

  11. Standby archiving parameters

  12. Switchover considerations

  13. Real application clusters guard architecture

  14. Real application clusters guard failover
TRANSPARENT APPLICATION FAILOVER

  1. Listeners

  2. Tns connect descriptors

  3. Network naming methods

  4. Oracle call interface

  5. Host based failover

  6. Real application clusters failover

  7. TAF in real application clusters

  8. Failover mode options

  9. Failover types

  10. Failover methods

  11. Failover backup service

  12. Failover connection reattempt options

  13. TAF implementation

  14. Connect- Time failover with client load balancing

  15. Retrying failover connections

  16. Preestablishing a connection for TAF

  17. TAF verification

  18. Simple Primary/Secondary configuration

  19. Primary/Secondary configuration with TAF

  20. Primary/Secondary configuration with TAF : example
BACKUP AND RECOVERY

  1. Protecting against media failure

  2. Log history recods

  3. Initiate archiving

  4. Archived log file configurations

  5. Oracle recovery manager

  6. Configurng RMAN

  7. RMAN default autollocation

  8. User – managed backup methods

  9. Offline user – managed backup

  10. Online user – managed backup

  11. Restoring & recovering redo log files

  12. Parallel recovery in RAC

  13. Fast – Start parallel rollback in RAC
ONLINE TRANSACTION PROCESSING CONSIDERATIONS

  1. Extent management options

  2. Locally managed tablespaces

  3. Dictionary managed tablespaces

  4. Free block management

  5. Automatic – segment space management

  6. Enable automatic segment – space management

  7. Free list space management

  8. Free list groups

  9. Manual allocation of free list groups to instances

  10. Automatic allocation of free list groups to instances

  11. Comparision of free space management methods

  12. Sequential numbers

  13. Sequence generators

  14. Sequence generator options

  15. Index leaf block contention

  16. Advances queuing considerations

  17. Queue table instance affinity

  18. Reducing queue table cache service resource requests

  19. Transaction processing in earlier releases
MONITORING AND TUNING

  1. Create real application clusters views

  2. Oracle performance manager

  3. Statspack

  4. Configure statspack

  5. Collect statspack statistics

  6. Generate statspack report

  7. Stats pack cluster statistics

  8. Monitor consistent block processing

  9. Global cache service request latency

  10. Monitor current block processing

  11. Monitor block mode conversions

  12. Analyse global enqueue statistics

  13. Collect global enqueue statistics

  14. Calculate average global enqueue time

  15. Calculate average global lock convert time

  16. Further analysis with V$LIBRARY CACHE and V$ROWCACHE

  17. Monitor global enqueue service resource statistics

  18. Analyze global enqueue service resource statistics

  19. Additional views to examine resource activity

  20. V$SYSTEM_EVENT view

  21. Real application clusters events in v$SYSTEM_EVENT

  22. General observations for tuning inter – instance performance

  23. Tuning strategy
 
   
 
     
 
Training Portfolio
 
 
Courses
Course material designed by experts
Tutorial
Certification Guidance
 
 
 
     
     
     
 
 
     
© 2009, qsoftindia.com, All Rights Reserved
`