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

SmartTier for Oracle use

cases

This chapter includes the following topics:

■ SmartTier for Oracle file-based use cases

■ SmartTier for Oracle sub-file use cases

SmartTier for Oracle file-based use cases

The following file-based use cases are supported for SmartTier for Oracle:

■ Migrating partitioned data and tablespaces

■ Scheduling the relocation of archive and Flashback logs

Migrating partitioned data and tablespaces

Perhaps the simplest application of multi-tier storage to databases is relocation

of individual table partitions between different placement classes as usage

requirements change. If exact relocation times are unpredictable, or if relocation

is infrequent, administrators may wish to relocate table partitions when necessary

rather than defining strict periodic relocation schedules.

Ad hoc relocation of table partitions can be useful, for example, with databases

that track sales and inventory for seasonal businesses such as sports equipment

or outdoor furniture retailing. As the selling season for one type of inventory (for

example, summer equipment or furniture) approaches, database table partitions

that represent in-season goods can be relocated to high-performance storage,

since they will be accessed frequently during the coming months. Similarly,

partitions that represent out-of-season goods can be relocated to lower-cost

storage, since activity against them is likely to be infrequent.

Chapter