Course Contents:
SQL Tuning
- Query Optimizer and Execution plan
- Index suggestions
- Query structure change
- Hints
- Tkprof analysis
- DBMS Profiler
- Various index scans vs Table scan
Automatics SQL Tuning
- Automatic tuning optimizer
- Statistics analysis
- Sql Profiling
- SQL tuning advisor
Oracle Enterprise Manager (OEM)
- DB Health check
- Performance monitoring
- Running above reports
Instance Tuning
- Memory tuning
- Automatic memory management
- Wait events
Report Analysis
- AWR
- ADDM
- ASH
Partition And Compression
- Partition types and benfits
- OLTP compression
- LOB compression with secure files
Segment Tuning
- Index rebuilding
- Segment move/shrink operations
- Segment advisor
Real Time Cases
- Tuning query in given time period
- Troubleshooting ongoing query issues
- Archival Process
- Partition Purge
- Separating report data using goldengate
