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

ITEM_ID and ITEM from the sample segments reported above are the two most
likely candidates for relocation to a higher performance tier. The commands to
relocate them are:
$ dbdst_obj_move -S $ORACLE_SID -H $ORACLE_HOME \
-i ITEM_ID -c SSD_TIER
$ dbdst_obj_move -S $ORACLE_SID -H $ORACLE_HOME \
-t ITEM -c SSD_TIER
For more on using the dbdst_obj_move command:
See “Administering SmartTier at the sub-file level” on page 266.
Relocating a hot database segment to a higher performance tier
You can relocate hot database segments or objects to higher performance storage
using sub-file storage tiering when relocating the entire datafiles is not practical.
For the example values in the procedure below, see the information in Table 15-1
The command in the example below queries dba_segments and dba_extents and
prepares a list of extents for a given table/index. From the extent information, a
list containing (file, offset) is generated. This list is handed over to fsppadm to
perform the sub-file enforcement.
To relocate a hot database segment to a high-performance tier
1
Identify the most active hot objects or segments of the database using an
Oracle AWR report.
2
Determine the size needed to relocate them to the higher-performance tier.
3
To ensure an up-to-date SFDB repository, run dbed_update.
4
Run the command to move the table emp to the tier SSD.
$ dbdst_obj_move -S PROD -H /ora11ghome -t EMP -c SSD
The command in the example below displays the set datafiles where the specified
table/index resides. If the underlying file system is a multi-volume file system, it
will display the corresponding volume and tier name.
To verify that the database segment is relocated to the correct tier
◆
Run the command to view the relocated table:
$ dbdst_obj_view -S PROD -H /ora11ghome -t EMP
For more on using the dbdst_obj_move command:
277SmartTier for Oracle use cases
SmartTier for Oracle sub-file use cases