This topic is not so specific as the others. It says "Support optimal data performance". This lead us to think in about 1000 items that are relates to performance in a DB. Basically, this means: study a lot of performance. Read the whole Oracle doc for Performance Tuning and get the OCE Performance Tuning.
This is the best way to be sure you are good with this topic.
I will list some items that I recommend studying:
- When to use AMM / ASSM
- When to use Shared Servers
- Tuning the DB_BLOCK_SIZE, DB_FILE_MULTIBLOCK_READ_COUNT
- Optimise the Shared Pool
- Tuning Filesystem IO with Sync / Async / Direct IO
- Tuning cursors with OPEN_CURSORS, SESSION_CACHED_CURSORS
- Using Parallelism
- OFA
- Tuning all the SGA and PGA pools
- Undo best practices (undo_management parameters)
- Fast Start Mean time to recovery parameter
- Statistics Level
- Keep frequent queries in the Shared Pool
Path to Documentation:
Performance Tuning Guide
Thanks to:
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
