VTC Legacy
Home / Programming

Oracle: Performance Tuning (1Z0-033)

by Gavin Powell
194 lessons19 chapters10.8 hReleased 20045 free
Start the free chapter

VTC author, <a href=\'http://www.vtc.com/modules/products/authorInfo.php?author=146\' target=\"_blank\">Gavin Powell</a>, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are sorting, locking, latches and wait events, shared or dedicated server processes, statistics, SQL code tuning and resource management. There is also brief coverage of tuning in the operating system, plus specialized objects use. To begin learning today, simply click on one of the <b>Oracle Performance Tuning (1Z0-033)</b> lessons.

Course content

Introduction5 lessons
What is Performance Tuning?9 lessons
Performance Tools10 lessons
Tuning the Shared Pool9 lessons
The Database Buffer Cache13 lessons
Other Buffers10 lessons
Tuning I/O: Physical File Structures14 lessons
Tuning I/O at the Block Level8 lessons
Tuning Sorts8 lessons
Locking Issues9 lessons
Latches and Wait Events21 lessons
Shared Servers and Dedicated Servers6 lessons
Statistics14 lessons
Applications and Specialized Objects13 lessons
SQL Code Tuning31 lessons
Resource Management5 lessons
The Operating System7 lessons
Conclusion1 lessons
Credits1 lessons