Improve job skills - Become more efficient - Produce better results !

Learn Oracle: Performance Tuning (1Z0-033) (in only 11 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course Description: VTC author, Gavin Powell, 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 Oracle Performance Tuning (1Z0-033) lessons.


Click a play button below to view a free training video. Place your order online for full access.

 

Video Tutorials Included: 191 Free Video Video Time
(minutes)

Tuning the Shared Pool

The Database Buffer Cache

Other Buffers

Tuning I/O: Physical File Structures

Tuning I/O at the Block Level

Tuning Sorts

Locking Issues

Latches and Wait Events

Shared Servers and Dedicated Servers

Statistics

Applications and Specialized Objects

SQL Code Tuning

Resource Management

The Operating System

Conclusion