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

■ Several extents are allocated from the same file such that 1MB of the datafile
is used by extents. In other words, each table will have 1MB of storage allocated
from a given datafile and all these extents are contiguous in the datafile.
This makes using SmartTier for Oracle to tier storage at the file portion level
practical.
Table 13-1
Recommended SmartTier option for Oracle use cases
Recommended SmartTier optionOracle file type
File-based storage tieringArchive logs
File-based storage tieringFlashback logs
File-based storage tieringPartitions
Sub-file based storage tieringTable relocation
Sub-file based storage tieringHot datafile
Sub-file based storage tieringPortions to SSD
About Automatic Workload Repository statistics
Starting with Oracle 10g, Oracle collects various statistics and stores it inside a
database repository called Automatic Workload Repository (AWR).
Statistics include:
■ CPU
■ Memory
■ File I/O
■ disk statistics
AWR is useful for finding usage trends, bottlenecks and improving performance.
By default, AWR snapshots are:
■ Taken every 60 minutes
■ Stored in AWR
■ Kept for seven days
Statistics interval and retention period can be changed via init.ora. Oracle
recommends a retention period of 30 days for statistics and provides tools to
collect extra statistics on demand. There are various scripts and tools available
243Understanding storage tiering with SmartTier
How SmartTier for Oracle works