Oracle Performance Tuning 1Z0 - 033 Tutorial Video

Self Study, Tutorial Video on CD - DVD. Tutor Gavin Powell guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users

These Oracle Performance tuning tutorials are an ideal resource for users that wish to study for the 1Z0 033 Oracle 9i certification. Expert Gavin Powell authors this training course which covers both fundamental and the more advanced aspects of this subject. Topics covered in this tutorial include: Performance tools, Shared Pool, Database Buffer Cache, Physical File Structures, Locking, Latches, Wait Events, SQL Code and much more. These lessons are conducted in a easy to follow format, and the delivery of the training via high quality QuickTime video ensures that the training is both informative and engaging.

. Watch our free Oracle Performance 1Z0 - 033 Tutorial Videos by clicking the blue lesson links below.

try for free

Oracle Performance 1Z0 - 033 Tutorial CD / DVD

Create the best self-paced learning environment
right on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Problems Playing the Demos?
Benefits
  • Professional Tuition from an Expert
  • Free Certificate with Each Tutorial
  • Works on PC or Mac
Just Released This Week
Apple Logic Pro 9 tutorial video
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction What is Oracle Performance Tuning? Oracle Performance Tools
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$149.95
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 Oracle Cursors
  • OEM and the Shared Pool
  • Oracle Performance Views Tutorials
The Oracle Database Buffer Cache
  • Database Buffer Cache Efficiency
  • OLTP Versus Data Warehouse
  • Configure the Database Buffer Cache
  • Examine the Database Buffer Cache
  • The Oracle 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 Oracle 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
  • Oracle 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 Tutorials
  • Tablespace Storage Structures
  • Dictionary Managed Tablespaces
  • Locally Managed Tablespaces
  • Finding Tablespace Problems
  • Redo and Archive Log Files Tutorials 1
  • Redo and Archive Log Files 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
Oracle Locking Issues
  • Locking Levels
  • Types of Contention Tutorials 1
  • Types of Contention 2
  • Types of Locks in Oracle
  • Detecting Lock Contention
  • How to Avoid Locking
  • Lock Monitoring and Removal in OEM
  • Performance and Metadata Views Tutorials 1
  • Performance and Metadata Views 2
Latches and Wait Events
  • What is a Latch?
  • Different Types of Latches
  • Shared Pool Latches 1
  • Shared Pool Latches 2
  • Oracle Database Buffer Cache Latches 1
  • Database Buffer Cache Latches 2
  • Database Buffer Cache Latches 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
  • Oracle Wait Events and Performance Views Tutorials 1
  • Wait Events and Performance Views 2
Statistics
  • What are Statistics?
  • The Importance of Realistic Statistics
  • Statistics and OPTIMIZER_MODE
  • Statistics and CURSOR_SHARING
  • CBO Parameters 1
  • CBO Parameters 2
  • CBO Parameters 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 Tutorials 1
  • Oracle Special Storage Structures 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 1
  • Oracle Partitioning Methods Examples 2
  • Metadata Views
Oracle SQL Code Tuning
  • Building Efficient SQL Code
  • Tuning Query Clauses Tutorials 1
  • Tuning Query Clauses 2
  • Tuning Query Clauses 3
  • Comparisons
  • Joins
  • Other Factors 1
  • Other Factors 2
  • SQL Code Execution Process
  • The Optimizer and What It Does
  • The Internal Machinations of the Optimizer 1
  • The Internal Machinations of the Optimizer 2
  • Hints
  • Types of Hints
  • Influence the Optimizer Tutorials 1
  • Influence the Optimizer 2
  • Alter Table Scans
  • Alter Index Scans Tutorials 1
  • Alter Index Scans 2
  • Modify Joins Tutorials 1
  • Modify Joins 2
  • Perform SQL in Parallel
  • Change Queries and Subqueries
  • Finding Queries with Problems
  • EXPLAIN PLAN and the PLAN_TABLE
  • Autotrace in SQL*Plus
  • Oracle SQL Trace and TKPROF 1
  • SQL Trace and TKPROF 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
Oracle Performance Conclusion
  • Wrapping it All Up!
Credits
  • About the Author and these Tutorials
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356