Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy


  Oracle Tips by Burleson

Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database Diagnostic Monitor

Uses of AWR

STATSPACK is one of the manual ways for looking at historical data. However, this required the DBA to know when and where to get the information, and how to apply that information to the problem. STATSPACK is still available in Oracle database 10g.

Here are a few items and features of AWR to keep in mind when contemplating the switch from STATSPACK.

  • In order to use the workload repository, application code will have to be changed. 

  • There is no supported path to migrate STATSPACK data into the workload repository. 

  • There is no view created on top of the workload repository to simulate the STATSPACK schema. 

  • Users who use AWR and STATSPACK at the same time will receive unwanted errors.

  • AWR utilizes historic data to compare against the current performance data of the system to identify performance bottlenecks, predict future problems, and to help improve the performance.

  • The AWR statistics data is accessible by DBAs, external users, and third party vendors to develop performance monitoring scripts and tools.

  • AWR can be used to perform trend analysis.

The next section will examine the architecture of AWR by describing some of the many statistics that are collected.

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

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks