Archive Log mode Quiesce and what happens.
Sequential Detection and Dynamic Prefetching.
Physical Data Organization Part-4. Simple tablespace space search algorithm.
Physical Data Organization Part-3. Clustering Basics.
Physical Data Organization Part-2. Space map page basics.
Physical Data Organization Part-1. Space map page basics.
Guess your Production access path and CPU cost even before you move your program to PROD.
Lock Avoidance. CLSN and PUNC tests.
Buffering , LRU chain maintinance, When can you use FIFO? Part-2
Quick recap of usage factor and how it affects performance of a system.
Buffering , do you know what really happens? Part-1
Data Distribution Statistics, Why is it important to know your data distribution?
What happens during a commit and a checkpoint? What is different?