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

Home
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


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

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:

www.oracle-script.com

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.