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

Table 14-5
dbdst_obj_view command options (continued)
DescriptionCommand option
Name of the table for which view report needs
to be generated.
-t table name
Name of the index for which view report needs
to be generated.
-i index name
Name of the partition for which view report
needs to be generated.
-p partition name
Specifies the starting extent of the table/index.
The default starting extent is zero.
-s start-extent
Specifies the last extent of the table/index . If
this option is not specified, then the report will
be generated to include last extent of the table.
-e end-extent
To verify objects have been moved as expected to a new tier
◆
Use following command to verify a relocation of the entire emp table to
SYMMETRIX, extents 100 to 400 of table emp to SSD, and partition q1_orders
to SSD.
$ /opt/VRTS/bin/dbdst_obj_view -S PROD -H /opt/oracle/home11g \
-t emp
File Name Ext-Id File-Offset Length Tier-Name
--------- ------ ----------- ------ ---------
/demo_data/emp1.dbf 1 8462336 1048576 SYMMETRIX
/demo_data/emp1.dbf 2 2170880 1048576 CLARION
/demo_data/emp1.dbf 3 3219456 1048576 CLARION
/demo_data/emp1.dbf 4 9510912 1048576 CLARION
/demo_data/emp1.dbf 5 12656640 1048576 CLARION
/demo_data/emp1.db 6 13705216 1048576 SYMMETRIX
/demo_data/emp1.db 7 14753792 1048576 SYMMETRIX
/demo_data/emp1.dbf 8 15802368 1048576 SYMMETRIX
/demo_data/emp1.db 16850944 1048576 SYMMETRIX
Administering SmartTier at the sub-file level
Use the dbdst_obj_move command to move the specified database table, index
or a partition files to the desired storage class. The dbdst_obj_move command
Configuring and administering SmartTier
Administering SmartTier at the sub-file level
266