Online Performance Manager eLearning Training
From 123-CBT Computer Based Training
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

...ontention.
View the name of locked table.
Launch Oracle Performance Manager and display the locks currently held.
Kill a session.
Examine a trace file in the USER_DUMP_DEST directory.
Unit 5: Resolving Contention Issues
Duration: 1 - 2 Hour(s)
Identify characteristics of contention.
Identify which areas the DBA can tune.
Identify different the characteristics of latch types.
more...
