– Learning How to Use MaxGauge –
01 What makes you wait?
02 Don’t stay up all night
03 Compare on a daily basis
04 Find the top N list
05 Capture the moment
06 Manage your RAC system
07 Secure more space
08 List up the issues
09 Don’t assume the results
10 One-click to finish
– Studying Oracle Performance Waits –
01 library cache pin
02 Log Buffer Space
03 latch: Shared Pool (Bind Mismatch)
04 Enq: TX – index contention
05 SGA: allocation forcing Component growth
06 gc cr/current block 2/3-way
07 SQL*Net more data from/to client
08 Cursor pin S wait on X
09 Enq: TX-allocate ITL entry
10 Log file parallel write
