Identifying and finding the cause for various types of latch contention is demonstrated through numerous SQL statements that hit Oracle???s various fixed tables and performance views, and he even shows a couple of examples of using TKPROF???s ORADEBUG to dump memory contents for analysis.