Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for download help.
- See right for full details on this Oracle Tutorial
- See far right to purchase this Oracle Training CD
Oracle: Performance Tuning (1Z0-033) Tutorial
Professionally created, self-study video training.
Expert author Gavin Powell
explains all the essential concepts and techniques in the 1Z0-O33 Oracle 9i tuning Certification exam
in an easy to follow manner, which will help you pass the test with confidence. Simply click any linked lesson below for FREE Oracle tutorial movies.
Try this training now - See below for FREE tutorials
All Courses on 1 or 2 CDs
For Mac and PC
Complete CD Contents and FREE Video Tutorials
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD. CLICK HERE TO BUY THIS CD
Tuning the Shared Pool
The Shared Pool
Shared Pool Efficiency
Shared Pool and Reserved Shared Pool
Library and Dictionary Cache Hit Ratios
Pinning Objects in the Shared Pool
The Large Pool
Caching Cursors
OEM and the Shared Pool
Performance Views
The Database Buffer Cache
Database Buffer Cache Efficiency
OLTP Versus Data Warehouse
Configure the Database Buffer Cache
Examine the Database Buffer Cache
The Buffer Cache Hit Ratio
Processes and the Buffer Cache
How to Tune Buffer Cache
How Else to Tune Buffer Cache
Free List Contention
Multiple Database Writers and Slaves
Monitor Buffer Cache and Subset Pools
OEM and the Database Buffer Cache
Performance and Metadata Views
Other Buffers
Tuning the Redo Log Buffer
Sizing the Redo Log Buffer
The Java Pool
Configuring Automatic PGA Memory
Configuring Manual PGA Memory
Tuning PGA Memory
Changing SGA Memory Online
SGA_MAX_SIZE
Changing Non SGA Memory Online
Performance Views
Tuning I/O: Physical File Structures
Datafiles/Tablespaces/Objects
Control Files and Recoverability
Distribution of Database Files
Dividing Data Across Tablespaces
Oracle Partitioning
Tablespace Storage Structures
Dictionary Managed Tablespaces
Locally Managed Tablespaces
Finding Tablespace Problems
Redo and Archive Log Files - Lesson 1
Redo and Archive Log Files - Lesson 2
Physical Structures in OEM
Performance Views
Metadata Views
Tuning I/O at the Block Level
Segments
Extents and Blocks
The High Water Mark
Reclaiming Unused Space
Row Chaining and Row Migration
Reorganizing Indexes
Detecting Problems With Indexes
Metadata Views
Tuning Sorts
How Does Sorting Work?
Which SQL Code Causes Sorting?
Demonstrating SQL Code Sorting
Sorting in Memory and on Disk
Analyzing Sorting
Minimizing Sorting
Sorting in OEM
Performance Views
Locking Issues
Locking Levels
Types of Contention - Lesson 1
Types of Contention - Lesson 2
Types of Locks
Detecting Lock Contention
How to Avoid Locking
Lock Monitoring and Removal in OEM
Performance and Metadata Views - Lesson 1
Performance and Metadata Views - Lesson 2
Latches and Wait Events
What is a Latch?
Different Types of Latches
Shared Pool Latches - Lesson 1
Shared Pool Latches - Lesson 2
Database Buffer Cache Latches - Lesson 1
Database Buffer Cache Latches - Lesson 2
Database Buffer Cache Latches - Lesson 3
Redo Log Latches
Session Connection Latches
Latch Spins, Misses and Sleeps
Latch Miss Rate
Latch Miss Total Time
What is a Wait Event?
Event Types and TIMED_STATISTICS
Idle Wait Events
Querying Significant Wait Events
Wait Events in an Active Database
Analyzing Significant Wait Events
The Wait Event Interface
The Wait Event Interface in OEM
Performance Views
Shared Servers and Dedicated Servers
Tuning Oracle Net Services
Shared Versus Dedicated Servers
Shared Server Configuration
Oracle Net Manager in OEM
Wait Events and Performance Views - Lesson 1
Wait Events and Performance Views - Lesson 2
Statistics
What are Statistics?
The Importance of Realistic Statistics
Statistics and OPTIMIZER_MODE
Statistics and CURSOR_SHARING
CBO Parameters - Lesson 1
CBO Parameters - Lesson 2
CBO Parameters - Lesson 3
Gathering Statistics using ANALYZE
Histograms and the ANALYZE Command
Gathering Statistics using DBMS_STATS
Gathering Statistics using OEM
What is STATSPACK?
Installing and Using STATSPACK
Metadata Views
Applications and Specialized Objects
Database Type Requirements
Oracle Special Storage Structures - Lesson 1
Oracle Special Storage Structures - Lesson 2
Applying Storage Structures
Creating BTree and Bitmap Indexes Syntax
Creating BTree and Bitmap Indexes Examples
Creating Index Organized Tables
Creating Clusters
Creating Materialized Views
Oracle Partitioning Methods Syntax
Oracle Partitioning Methods Examples - Lesson 1
Oracle Partitioning Methods Examples - Lesson 2
Metadata Views
SQL Code Tuning
Building Efficient SQL Code
Tuning Query Clauses - Lesson 1
Tuning Query Clauses - Lesson 2
Tuning Query Clauses - Lesson 3
Comparisons
Joins
Other Factors - Lesson 1
Other Factors - Lesson 2
SQL Code Execution Process
The Optimizer and What It Does
The Internal Machinations of the Optimizer - Lesson 1
The Internal Machinations of the Optimizer - Lesson 2
Hints
Types of Hints
Influence the Optimizer - Lesson 1
Influence the Optimizer - Lesson 2
Alter Table Scans
Alter Index Scans - Lesson 1
Alter Index Scans - Lesson 2
Modify Joins - Lesson 1
Modify Joins - Lesson 2
Perform SQL in Parallel
Change Queries and Subqueries
Finding Queries with Problems
EXPLAIN PLAN and the PLAN_TABLE
Autotrace in SQL*Plus
SQL Trace and TKPROF - Lesson 1
SQL Trace and TKPROF - Lesson 2
Finding Bad Queries in OEM
Plan Stability and Stored Outlines
Performance and Metadata Views
Resource Management
The Oracle Resource Manager
Resource Manager Components
Resource Plan Directives
Create Groups and Plans and Allocate
Metadata and Performance Views
The Operating System
Basic Operating System Tuning
Virtual Memory/Paging/Swapping
What Determines I/O Distribution?
Database Function and Methods of Distribution
Oracle Database File Types Distribution
Database Block Size
Resource Consumption in OEM
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649