Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

■ Relocating old table data to a lower cost tier
Using AWR statistics to identify sub-file objects for potential relocation
You can use Oracle's Automatic Workload Repository (AWR) statistics to identify
sub-file objects for potential relocation by identifying key properties such as
activity levels. The Oracle database collects these statistics for a variety of
purposes, including making self-management decisions. See the guidelines below
for enabling AWR and generating AWR reports.
To enable AWR statistics collection
◆
Specify the level of collection for database and operating system statistics
by setting the initialization parameter: STATISTICS_LEVEL:
■ TYPICAL: is the default setting. This setting ensures collection of all major
statistics required for database self-management functionality and
provides best overall performance. The default value should be adequate
for most environments.
■ ALL: additional statistics are added to the set of statistics collected with
the TYPICAL setting. The additional statistics are timed OS statistics and
plan execution statistics.
■ BASIC: disables the collection of many of the important statistics required
by Oracle database features and functionality.
Symantec recommends setting STATISTICS_LEVEL = typical .This parameter can
be dynamically changed when database is online.
To change the STATISTICS_LEVEL
◆
Use the following:
SQL> alter system set statistics_level=typical;
An AWR report shows data captured between two snapshots (or two points in
time). The AWR reports are divided into multiple sections. The HTML report
includes links that can be used to navigate quickly between sections. The content
of the report contains the workload profile of the system for the selected range
of snapshots.
275SmartTier for Oracle use cases
SmartTier for Oracle sub-file use cases