Oracle Performance Tuning 1Z0 - 033 Tutorials

Details

Highly Effective Oracle Performance 1Z0 - 033 tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on 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.


Close

Oracle Performance 1Z0 - 033 Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Oracle Performance 1Z0 - 033 Tutorial Videos.

Try 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.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
This tutorial can also be viewed using Flash:
Click To View in Flash
Introduction  Welcome Demo
 Prerequisites for this Course Demo
 About this Course pt. 1 Demo
 About this Course pt. 2 Demo
 Oracle Tuning Documentation Demo
What is Performance Tuning?  Who Tunes and What Do They Tune? Demo
 The Different Stages of Tuning Demo
 Development/Testing/Production Demo
 Statistics and Performance Evaluation Demo
 Goal Oriented Tuning Demo
 Common Problems pt. 1 Demo
 Common Problems pt. 2 Demo
 Performance Versus Integrity Demo
 Oracle Enterprise Manager (OEM) Demo
Performance Tools  The Alert Log Demo
 Process Trace Files Demo
 User Trace Files Demo
 Setting Up Tracing Demo
 TKPROF Demo
 Manually Collecting Statistics Demo
 STATSPACK and Collecting Statistics Demo
 Collecting Statistics in OEM Demo
 Introducing the Wait Event Interface Demo
 What to Tune Demo
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 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 pt. 1
Redo and Archive Log Files pt. 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 pt. 1
Types of Contention pt. 2
Types of Locks
Detecting Lock Contention
How to Avoid Locking
Lock Monitoring and Removal in OEM
Performance and Metadata Views pt. 1
Performance and Metadata Views pt. 2
Latches and Wait Events What is a Latch?
Different Types of Latches
Shared Pool Latches pt. 1
Shared Pool Latches pt. 2
Database Buffer Cache Latches pt. 1
Database Buffer Cache Latches pt. 2
Database Buffer Cache Latches pt. 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 pt. 1
Wait Events and Performance Views pt. 2
Statistics What are Statistics?
The Importance of Realistic Statistics
Statistics and OPTIMIZER_MODE
Statistics and CURSOR_SHARING
CBO Parameters pt. 1
CBO Parameters pt. 2
CBO Parameters pt. 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 pt. 1
Oracle Special Storage Structures pt. 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 pt. 1
Oracle Partitioning Methods Examples pt. 2
Metadata Views
SQL Code Tuning Building Efficient SQL Code
Tuning Query Clauses pt. 1
Tuning Query Clauses pt. 2
Tuning Query Clauses pt. 3
Comparisons
Joins
Other Factors pt. 1
Other Factors pt. 2
SQL Code Execution Process
The Optimizer and What It Does
The Internal Machinations of the Optimizer pt. 1
The Internal Machinations of the Optimizer pt. 2
Hints
Types of Hints
Influence the Optimizer pt. 1
Influence the Optimizer pt. 2
Alter Table Scans
Alter Index Scans pt. 1
Alter Index Scans pt. 2
Modify Joins pt. 1
Modify Joins pt. 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 pt. 1
SQL Trace and TKPROF pt. 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
Conclusion Wrapping it All Up!
Credits About the Author

Oracle Performance 1Z0 - 033 Training CD Information

Title : Oracle Performance 1Z0 - 033
Tutor : Gavin Powell
Other tutorials and training by this author
Movies : 194 Lessons- Video run time: 11 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2004-12-19
Price US / Canadian Sales $99.95

188 In Stock

Add to Cart

Why use this method of video training ?
  • Learn Oracle Performance 1Z0 - 033 from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Oracle Performance 1Z0 - 033 course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Oracle Performance 1Z0 - 033 certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.