Oracle: Performance Tuning (1Z0-033) - Software Training and Tutorials on CD and Online

VTC author, Gavin Powell, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are sorting, locking, latches and wait events, shared or dedicated server processes, statistics, SQL code tuning and resource management. There is also brief coverage of tuning in the operating system, plus specialized objects use.

Oracle: Performance Tuning (1Z0-033) - Your Learning Options

Access the complete Oracle: Performance Tuning (1Z0-033) Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Oracle: Performance Tuning (1Z0-033) plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS

Learn Oracle: Performance Tuning (1Z0-033) from our PC and Mac compatible CDRom. The affordable price of $124.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Oracle: Performance Tuning (1Z0-033)
- Information About This Title -

Click Here To Purchase

Proper Title:	Oracle: Performance Tuning (1Z0-033)
Description:	Click here to open / close full description VTC author, Gavin Powell, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are sorting, locking, latches and wait events, shared or dedicated server processes, statistics, SQL code tuning and resource management. There is also brief coverage of tuning in the operating system, plus specialized objects use. -Close-
Instructor:	Gavin Powell (more by this author)
Instruction:	194 Tutorials - Duration: 11 hrs
First Release:	2004-12-15
Compatitibility:	Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock?	Yes - 2-5 days shipping
Price:	$124.95 $99.95 ON SALE!

Click Here To Purchase

Why Learn With VTC?!

Let an expert teach you Oracle: Performance Tuning (1Z0-033)
No classrooms or schedules - you learn on YOUR terms
No books to read - watch instructional video right on your computer
VTC training methods ensure the highest possible retention and fastest learning
Use VTC materials for future reference / refresher
Share CDRom training with others, friends, colleagues
Used by many schools, universities, and big business world wide
The most cost effective training available for Oracle: Performance Tuning (1Z0-033)

Below is content list for all of the lessons included with the Oracle: Performance Tuning (1Z0-033) Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.

Free Demo Lessons

Introduction

Welcome

Prerequisites for this Course

About this Course pt. 1

About this Course pt. 2

Oracle Tuning Documentation

What is Performance Tuning?

Who Tunes and What Do They Tune?

The Different Stages of Tuning

Development/Testing/Production

Statistics and Performance Evaluation

Goal Oriented Tuning

Common Problems pt. 1

Common Problems pt. 2

Performance Versus Integrity

Oracle Enterprise Manager (OEM)

Performance Tools

Manually Collecting Statistics

STATSPACK and Collecting Statistics

Collecting Statistics in OEM

Introducing the Wait Event Interface

What to Tune

... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

	Subscribe Now!
	Online University Info
	Purchase CDRom Now

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

Online Learning | Contact Us | Tech Support |

VTC Canada
sales@vtcCanada.com