Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle10g tuning articles

Oracle Tips by Burleson Consulting

Oracle Grid Tuning

OEM Wait Event Metrics

SQL Advisors

Oracle Time Series Tuning Tools

Automated Maintenance Tasks

Proactive Oracle Tuning

Oracle Hardware Performance Review

Oracle bottlenecks Identification

Oracle CPU Constrained Database

Oracle finding missing indexes

Oracle shared_pool_size tuning

Oracle Shared Pool Advisory Utility

Oracle AWR wri$, wrh$ and wrm$

Oracle AWR vs. STATSPACK table names

Oracle dba_hist Data Dictionary Views

Oracle dba_hist_system_event

Oracle dba_hist_bg_event_summary

Oracle dba_hist_waitstat

Oracle dba_hist_enqueue_stat

Oracle dba_hist_filemetric_history

Oracle dba_hist_sysmetric_history

Oracle dba_hist_sysmetric_summary

Oracle dba_hist_waitclassmet_history

Oracle dba_hist_sys_time_model






Operating System OS Statistics in AWR

dba_hist_sqlstat View

Oracle Segment Statistics dba_hist_seg_stat

Installation Files with STATSPACK

AWR dbms_workload_repository .modify_snapshot_settings

AWR snap_level Parameter

STATSPACK Collection Thresholds



Oracle10g Time Model v$ Views

Oracle 10g Database Metric v$ Views

Oracle v$sysmetric_history



Changes to 10g SQL v$ Views

AWR statistics_level

v$metricgroup and MMON

v$sysmetric and v$sysmetric_history


v$filemetric_history view scripts

v$servicemetric scripts

Oracle Creating an AWR Report

dbms_advisor quick_tune option

dbms_sqltune Package tasks

v$sys_time_model scripts

v$sess_time_model scripts

Generating the AWR Report

Oracle AWR Report Summary

Oracle AWR Report Cache Sizes

AWR Report Load Profile

Oracle Instance Efficiency Percentage

Oracle Top 5 Timed Events

Oracle Time Model Statistics

Oracle Operating System Statistics

Oracle AWR Instance Activity Section

Oracle I/O Reports

Oracle Buffer Pool Advisory

Oracle Latch Statistics

Oracle Segment Statistics


Oracle AWR Exception Reporting

Oracle trend identification

Oracle Server Tuning

Oracle Server Bottlenecks

Oracle Disk I/O

Moore’s Law

Oracle Server RAM

Oracle Enterprise Manager OEM for Servers


Oracle automatic_ipc parameter

Oracle Disk Monitoring

Oracle Disk Architecture

Oracle Disk Monitoring

Oracle Disk Statistics


Oracle Session I/O

Oracle Instance Configuration

Oracle Kernel Parameters

Oracle Hidden Parameters

Oracle duplicate RAM caches

Oracle AWR statistics with dba_hist_buffer_pool_stat


Oracle full table scans

Oracle high resource SQL

AWR and SQL Tuning


Tracking nested loop SQL joins

Tracking Oracle full table scans

Tracking Oracle hash joins

Oracle SQL Tuning Advisor

Oracle ASH

Oracle ASH in OEM

Oracle wait classes

Oracle V$Session_Event

Signature Analysis of Wait Events


Oracle Segment Header Contention

Oracle ASSM Performance

Online Table Reorganization


Oracle STAR Transformations and SQL

Oracle 10g for the Data Warehouse

Oracle Data Warehouse Scalability

Oracle OEM

Oracle OEM Alerts

Oracle OEM Tuning



OEM for UNIX Server Monitoring

Oracle dbms_advisor ADDM

ADDM SQLTuning Advisor

SQL Tuning in OEM

Oracle 10g SQL Tuning Sets

Oracle 10g SQL Access Advisor

Oracle 10g Memory Advisor




This is an excerpt from my latest book "Oracle Tuning: The Definitive Reference". 

You can buy it direct from the publisher for 50%-off and get instant access to the code depot of Oracle tuning scripts:




Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational