What are some effective tuning strategies for ensuring the best performance from Oracle database applications?
What are the overall concepts behind Oracle tuning?
How doe Oracle tuning and disk I/O; tuning with RAM data buffers; using multiple block sizes; disk I/O tuning; external tuning; and row re-sequencing work?
What are the underlying processes that affect the performance of Oracle databases?
What are the major causes of poor performance within Oracle?
How do experts ensure that the Oracle database is performing at an optimal level?
- high - medium - low
Application Development
Business Applications
Data Management
IT Management
Independent Oracle database expert and author Donald Burleson describes some of his most effective tuning strategies for ensuring the best performance from Oracle database applications. In addition to presenting the overall concepts behind Oracle tuning, Burleson discusses subjects such as: Oracle tuning and disk I/O; tuning with RAM data buffers; using multiple block sizes; disk I/O tuning; external tuning; and row re-sequencing. He also focuses on Oracle SQL tuning; tuning Oracle sorting; and tuning Oracle contention. This program explains to IT managers and DBAs the underlying processes that affect the performance of Oracle databases. In addition, Burleson explores the major causes of poor performance within Oracle, and demonstrates through tuning examples how experts ensure that the Oracle database is performing at an optimal level.
For those with access to the CD and online versions, this program provides a selection of Web links, including articles such as, 'Check for Chained Rows' from Oracle Magazine and 'How Big Should This Index Be?' from dbazine.com, that explore the factors that can have a negative effect on the Oracle database's performance. White papers such as 'Oracle DBA: Physician or Magician?' discuss a systematic approach for Oracle DBAs to identify and modify the factors causing performance bottlenecks in their database.
PROGRAM TOPICS:
INTRODUCTION
AGENDA
ORACLE TUNING AND DISK I/O
Reducing Disk I/O: Tuning SQL Statements
Reducing Disk I/O: Table Reorganizations
TUNING WITH RAM DATA BUFFERS
The KEEP Pool
Identifying Appropriate Tables for the KEEP Pool
Generating the KEEP Syntax
The RECYCLE Pool
USING MULTIPLE BLOCK SIZES
Improving Performance by Increasing Block Size
Segregate Tables to Maximize Available RAM Memory for the Data Buffers
DISK I/O TUNING
Identifying Hot Files and Disks
Cardinal Rules for Disk I/O: Understand Disk I/O Fully
Cardinal Rules for Disk I/O: Always Monitor Disk I/O
Cardinal Rules for Disk I/O: Use RAID Properly
Cardinal Rules for Disk I/O: Control Where Disk I/O Happens
Using Statspack to Capture I/O Information
Setting the Thresholds for rpt_hot_files.sql
DBAs Should Constantly Monitor for Hot Files
EXTERNAL TUNING
External Tuning: CPUs
External Tuning: RAM and Network Traffic
External Bottlenecks Must Be Eliminated Before Tuning the Database
Two Things to Monitor: Run Queue Waits
Two Things to Monitor: RAM Page-ins
Viewing Server Statistics
ROW RESEQUENCING
Reducing Disk I/O to Increase Performance
Reducing Disk I/O: Reorganize Tables Using CTAS for Row Resequencing
Sample Index Query Before and After Row Resequencing
Determining How Well Table Rows Match Index Sequence Keys
Using Oracle Tools to Reap the Rewards of Row Resequencing
ORACLE SQL TUNING
Goals of SQL Tuning: Remove Unnecessary Large Table Full Table Scans
Goals of SQL Tuning: Cache Small Table Full Table Scans
Goals of SQL Tuning: Verify Optimal Index Usage
Goals of SQL Tuning: Verify Optimal Join Techniques
Oracle SQL Tuning: Additional Information
ORACLE SORTING
Balancing Act: Determining the Sort Area
When Disk Sorts Happen to Good DBAs
TUNING ORACLE CONTENTION
Understanding and Managing Freelists and Freelist Groups
Freelist Link, Unlink and Relink: The PCTFREE and PCTUSED Parameters
- high
- medium
- low
