Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Easy Oracle Automation
Chapter 7 -
Application and SQL Management

Automatic Workload Repository

  • Time Model - Connection management, PL/SQL compilation, parse, SQL execution, and PL/SQL execution are available using v$sys_time_model.

  • SQL Statistics - SQL statistics include PL/SQL Java time and wait-class time, bind variables, efficient top SQL based on CPU, elapsed and parse statistics.

Automatic Database Diagnostic Monitor

Automatic Database Diagnostic Monitor (ADDM) analyzes the information collected by the AWR for database performance problems including top SQL statements. The database automatically captures statistical information from the SGA and stores the information inside the workload repository in the form of snapshots in one hour intervals. These snapshots are written to disk and are similar to STATSPACK snapshots, except they are more detailed in nature.

The ADDM is also scheduled to run the MMON process automatically on every database instance to detect problems proactively. Every time a snapshot is taken, the ADDM triggers an analysis of the period corresponding to the last two snapshots. Although this automatic analysis covers the previous two snapshots, ADDM can analyze across any two snapshots.

The above text is an excerpt from:

Easy Oracle Automation
Oracle10g Automatic Storage, Memory and Diagnostic Features

ISBN 0-9745993-6-0

by Dr. Arun Kumar R.

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.