Using Oracle Blocks Efficiently
Database Storage hierarchy
Allocating extents
Monitoring Space Usage in Data Segments
Recovering space from sparsely populated segments
Monitoring Space Usage in Index Segments

SQL Statement Tuning
Cost-based, Rule-based Optimizer Modes
New Cost Based Optimizer option
Plan Stability
Plan Equivalence
Stored Outlines
Hints
Diagnosing SQL statements
Managing Statistics

Tuning the Operating System and Using Resource Manager
System Architecture
Virtual and Physical Memory
Paging and Swapping
Tuning (Memory & I/O)
CPU Tuning Guidelines
Process Vs Thread
Resource Manager Concepts

Section 4: Project
Time Allocated - 6~9 hours

Previous page << pg1 pg2 pg3 pg4 pg5 pg6 pg7 pg8 pg9 pg10 pg11 pg12 PAGE13