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.
Who Tunes and What Do They Tune?
The Different Stages of Tuning
Development/Testing/Production
Statistics and Performance Evaluation
Oracle Enterprise Manager (OEM)
Manually Collecting Statistics
STATSPACK and Collecting Statistics
Introducing the Wait Event Interface
Shared Pool and Reserved Shared Pool
Library and Dictionary Cache Hit Ratios
Pinning Objects in the Shared Pool
Database Buffer Cache Efficiency
Configure the Database Buffer Cache
Examine the Database Buffer Cache
Processes and the Buffer Cache
Multiple Database Writers and Slaves
Monitor Buffer Cache and Subset Pools
OEM and the Database Buffer Cache
Performance and Metadata Views
Control Files and Recoverability
Distribution of Database Files
Dividing Data Across Tablespaces
Dictionary Managed Tablespaces
Redo and Archive Log Files pt. 1
Redo and Archive Log Files pt. 2
Row Chaining and Row Migration
Detecting Problems With Indexes
Which SQL Code Causes Sorting?
Demonstrating SQL Code Sorting
Lock Monitoring and Removal in OEM
Performance and Metadata Views pt. 1
Performance and Metadata Views pt. 2
Database Buffer Cache Latches pt. 1
Database Buffer Cache Latches pt. 2
Database Buffer Cache Latches pt. 3
Latch Spins, Misses and Sleeps
Event Types and TIMED_STATISTICS
Querying Significant Wait Events
Wait Events in an Active Database
Analyzing Significant Wait Events
The Wait Event Interface in OEM
Shared Versus Dedicated Servers
Wait Events and Performance Views pt. 1
Wait Events and Performance Views pt. 2
The Importance of Realistic Statistics
Gathering Statistics using ANALYZE
Histograms and the ANALYZE Command
Gathering Statistics using DBMS_STATS
Gathering Statistics using OEM
Installing and Using STATSPACK
Oracle Special Storage Structures pt. 1
Oracle Special Storage Structures pt. 2
Creating BTree and Bitmap Indexes Syntax
Creating BTree and Bitmap Indexes Examples
Creating Index Organized Tables
Oracle Partitioning Methods Syntax
Oracle Partitioning Methods Examples pt. 1
Oracle Partitioning Methods Examples pt. 2
The Optimizer and What It Does
The Internal Machinations of the Optimizer pt. 1
The Internal Machinations of the Optimizer pt. 2
EXPLAIN PLAN and the PLAN_TABLE
Plan Stability and Stored Outlines
Performance and Metadata Views
Create Groups and Plans and Allocate
Metadata and Performance Views
Virtual Memory/Paging/Swapping
What Determines I/O Distribution?
Database Function and Methods of Distribution
Oracle Database File Types Distribution
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.