Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

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.

Associated Tutorials: C Video Tutorial | JAVA | Microsoft .NET Framework | JavaScript | Novell Zenworks - ZDM7 | Fedora

Oracle Performance 1Z0 - 033 Tutorial CD / DVD

When you order this Oracle Performance 1Z0 - 033 Video Tutorial CD You'll Receive...
Over 11 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Oracle Performance 1Z0 - 033 from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I spent a lot of time trying to figure it on my own but I was going about everything the wrong way...your tutorial gave me a proper introduction to the software and it's much easier than I thought...thank you. "Leonard Howell, British Columbia

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.

Topics Covered on this Training Course

This Training is 11 Hours in Duration and Covers 194 Lessons.
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.
$99.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

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Oracle Performance 1Z0 - 033 Training CD

Title Oracle Performance 1Z0 - 033
Tutor Gavin Powell
Other tutorials by Gavin Powell
Videos 194 Lessons- Video run time: 11 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2004
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not Enabled on this title
164 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Oracle Performance 1Z0 - 033 from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Oracle PL/SQL | Microsoft SQL Server Admin Tutorials | Microsoft SQL Server Programming| Online Oracle Performance 1Z0 - 033 Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.