New AWR Snapshot Dialog

The New AWR Snapshot dialog allows you to create a new AWR snapshot.

Creating a New AWR Snapshot

An AWR Snapshot is a collection of database statistics and performance metrics gathered at a single point in time. Two snapshots are required to analyze database performance over their time period. This performance analysis is done by creating an ADDM Task.

See Also:

  • Using the Oracle Performance Analyzer for more information about performance tuning

  • Oracle Database Performance Tuning Guide - Chapter 5, Automatic Performance Statistics; Chapter 6, Automatic Performance and Diagnostics

Starting the New AWR Snapshot Dialog

To start the New AWR Snapshot dialog, right-click on AWR Snapshots Node and select New AWR Snapshot from the menu.

Description of newawrsnapshot.gif follows
Description of the illustration newawrsnapshot.gif

When the New AWR Snapshot dialog appears, specify Typical or All from the list as the Snapshot Level. Snapshot Level determines the amount of performance statistics that are gathered. This can be set to either the default value of TYPICAL or a value of ALL. When the statistics level is set to ALL, the AWR gathers the maximum amount of performance data including additional statistics such as timed OS statistics and plan execution statistics. Note that choosing ALL increases the database workload required to create the snapshot.

See Also

Oracle Database Performance Tuning Guide

Using the New AWR Snapshot Dialog

The New AWR Snapshot dialog controls are as follows:

Control Description

Specify Snapshot Level

Possible values are:

TYPICAL (default) - This ensures collection of all major statistics required for database self-management functionality and provides the best overall performance. This setting should be adequate for most environments.

ALL - This includes the statistics collected with the TYPICAL setting and additional statistics including timed OS statistics and plan execution statistics.

OK

Closes the dialog and creates the AWR snapshot.

Cancel

Closes the dialog without performing any actions.