Oracle Performance Tuning 1Z0 - 033 Tutorial Video

Details

This Oracle Performance 1Z0 - 033 tutorial offers users an cost effective way to master this application it days. Presented using narrated QuickTime videos that work on both PC and Mac platforms. This training CD uses practical examples and easy to follow step by step instructions to convey knowledge and accelerate the learning process, users of this training product will benefit from a degree of clarity and retention that other forms of training fail to match. Most of the tutorials are suitable for beginner to intermediate users.
Close

Oracle Performance 1Z0 - 033 Video Training

Contents

All the topics covered by this Oracle Performance 1Z0 - 033 Training CD are listed below. The blue links are FREE Demos. Suitable for use on PC or MAC.

Try for FREE - NOW

QuicktimeInformation on the free demos.
So you can sample the high quality of this training product we have made available the first free chapters for free. On the purchased product the entire listing below is included. Please note the sound and video quality of the free demos has been compressed for faster internet delivery, the audio and video on the purchased CDs is much higher. In order to play the free demos Apple QuickTime 7 or above is needed if required

Click here to Buy This Video DVD

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


If you purchase the CD all the contents listed below are also included.


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 Tutorial Video Information

Product Title: Oracle Performance 1Z0 - 033
Trainer: Gavin Powell
Other Training courses by this author
Movie Details: 194 Lessons- Video run time: 11 Hours
Price North America $99.95
Price for Europen Sales £71.95 ( + Vat )
Delivery: 3 working days ( UK / USA and Canada )
Suitable for: Win 95, 98, 2000, NT, XP, Mac OS, OSX

738 In Stock

BUY THIS VIDEO


Benefits of this training method
  • Unique accelerated learning, master Oracle Performance 1Z0 - 033 in days.
  • All training courses are taught by leading experts
  • Highly informative with an unmatched level of retention
  • Easy to follow step-by-step instructions
  • Ideal for single of multi users,
  • Users control the pace of the training, lessons can be stopped, rewound or fast-forwarded at any time.
  • More cost effective than a classroom training course, learn when it suits you.

Unrestricted Access to every training video - $30.00

Not sure which training CD to purchase? Why not have unlimited access to the entire range of training videos featured on this site for an unbelievable price of just $30 per month, that’s a massive 4,500 hours worth.

online people

Over 4000 hours of high quality training videos covering more than 350 of the most sort after software experts, accessible right from your own desk top, and all for just $30 per month.
No minimum sign up period
For Companies and Schools we offer a Multi User version complete with control panel, monitor usage, download reports, grant access and more.

Once signed up access is granted instantly to over 350 different titles with totally no restrictions, you can view as many different titles as you wish, there are no limits on how long you can log in for, you can even access from any computer.

This is without a doubt the most comprehensive source of high quality training on the web, and all at an unbelievable low price.

Learn even the most complex applications without having to read a manual or attend expensive classroom type training, learn when it’s convenient to you.

New titles are added each month, and as a member you will also have unlimited access to these as well.l.

Most of the training titles also have exercise files, these are included at no extra charge.

On completion of each course users can obtain a certification to verify the training.

Free Training Newsletter

Sign up for our free newsletter and get updated on when new titles are realised, and or when special offers are available
Your details are secure we never traded, sell or otherwise exchange your data with any third parties.