Oracle: Performance Tuning (1Z0-033) Training - Tutorial Videos

Training CDs > Certification Tutorial Videos > PERFORMANCE TUNING ORACLE: 1Z0-033

Oracle: Performance Tuning (1Z0-033) Tutorial CD

Affordable Training you can depend on
This Oracle: Performance Tuning (1Z0-033) training video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 11 hours long these Oracle: Performance Tuning (1Z0-033) tutorials on DVD / CD are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training DVD CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of these Performance Tuning Oracle: 1Z0-033 training videos we have made the first 3 chapters of this tutorial available for free viewing online. The purchased version of this video training course contains all the topics listed below. Please Note: the free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far higher. To play the free demo videos you will need QuickTime, click here to download if needed »

THIS TRAINING - TUTORIAL COVERS THE FOLLOWING:

Details

This Oracle Tuning Training DVD - Tutorial Video highlights how to optimize your Oracle database to run at it’s optimal level, users will be able to diagnose and solve core problems quickly. This Oracle training DVD is an essential reference for users who are studying for the exam certification 1Z0-033. The visual format of this training video will greatly reduce the required study time needed to pass this converted certification.

Topics covered on this Oracle tutorial include: Introduction, Trace Files, Alert Log, TKPROF, Shard Pool, Buffer Cache, Metadata Views, PGA Memory, Log Buffer, SGA MAX SIZE, Database Files, Table Space, Index Problems, Tuning Sorts, Locking Levels, Wait Events, Latches, Optimizer Mode, Statspack, Clusters, Tuning SQL Code, Oracle Database Block Size and much more.

The Blue Links below are free demos, when you purchase the video training DVD / CD the enitre content listings below are included , not just the free demo videos.

Select the format in which to view the free demos:

Introduction

What is Oracle Performance Tuning?

Oracle Performance Tools

The purchased version of this product contains all the movies listed below as well as all the featured samples above.

US$ 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

Performance Tuning Oracle: 1Z0-033 Training - INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Oracle: Performance Tuning (1Z0-033)
Instructor	:	Gavin Powell
Price	:	US$ 99.95
Duration	:	11 hours - 194 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33582

BENEFITS OF THIS TRAINING COURSE

Learn Performance Tuning Oracle: 1Z0-033 in the shortest time possible
Self paced tutorial, training on video, learn at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.

Prove your Skills. Free Certification with every course.

With every training course purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.