Oracle: Performance Tuning 1Z0-033 Tutorials

Course Title: Oracle: Performance Tuning 1Z0-033

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. To begin learning today, simply click on one of the Oracle Performance Tuning (1Z0-033) lessons.

*View other requirements of the Oracle Certification by clicking here.

Course Author/Expert: Gavin Powell

Language: english

Full Online Training Available: Yes

Number of Course Movies: 194

Course Duration: 11 hours

Never has it been so easy to learn Oracle: Performance Tuning 1Z0-033.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.

Course Outline:

The FIRST THREE chapters of this online training course can be viewed right now!

Click Here Now To View the First Three Chapters of Oracle: Performance Tuning 1Z0-033 Online Training For Free

If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.

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