dbdst_obj_view - view the specified database objects like table, index or partition and see which storage class each extent resides.

dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME

     -t <table name> [-s <start extent>] [-e <end extent>]

dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME

     -i <index name> [-s <start extent>] [-e <end extent>]

dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME

     -p <partition name> [-s <start extent>] [-e <end extent>]

dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME

     -f <datafile>

Veritas Storage Foundation. To determine whether this product is installed on a Linux system, enter:

rpm -qa | grep VRTSdbed

The dbdst_obj_view command is used to get a detailed report for the specified database table, index or a partition. The report displays in which storage class each database table/index extent resides. A DBA can use this report and make decisions to move the database objects within different storage clases of the Multi-volume Filesystem. An Oracle tablespace is usually constructed of several datafiles. A database object like table/index has extents allocated from multiple datafiles. A given datafile usually contains extents from multiple database objects.

The dbdst_obj_view command queries oracle dba_extents catalog table and for each extent gets file offset and length in bytes. This command passes these offset/length information to VxFS low level SmartTier commands to get the exact location of the extent blocks .

The following options are supported:

-S ORACLE_SID
	Specifies the name of the Oracle database from which information will be retrieved.
-H ORACLE_HOME
	Specifies the ORACLE_HOME for the database.
-t table name	Name of the table for which view report needs to be generated.
-i Index name	Name of the index for which view report needs to be generated.
-p partition name
	Name of the partition for which view report needs to be generated.
-f datafile	Name of the datafile for which view report needs to be generated. With this option, start-extent and end-extent can not be specified.
-s start-extent
	This option specifies the starting extent of the table/index. The default starting extent is zero.
-e end-extent
	This option specifies the last extent of the table/index . If this option is not specified, then the report will be generated to include last exetent of the table.

This command is supported in a RAC environment. This command can be run on any node of the oracle RAC cluster. Since this command queries the Database, the instance need to be up where the command is executed.

Use following command to move entire emp table to SYMMETRIX. Move extents 100 to 400 of table emp to SSD. Move partition q1_orders to SSD and verify it.

$ /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.dbf 6 13705216 1048576 SYMMETRIX
/demo_data/emp1.dbf 7 14753792 1048576 SYMMETRIX
/demo_data/emp1.dbf 8 15802368 1048576 SYMMETRIX
/demo_data/emp1.dbf 9 16850944 1048576 SYMMETRIX
/demo_data/emp1.dbf 10 17899520 1048576 SYMMETRIX

This command must be run as Oracle DBA user. This command must executed when the database is online. Generating a report for large tables will take long time. Please use start/end extents to restrict scope of the table/index.

dbed_update must be run at least once before this command to ensure an up-to-date repository.

0	Command executed successfully.
1	An Error Occured.
101	Licence check failed.
102	No license to execute this command.
103	Invalid Storage Class
104	The device or mount point is not owned by user
105	Could not get information from Oracle Database
255	Could not load program.

RAC is not supported with some SF products/configurations. For details please refer to the Veritas Storage Foundation: Storage and Availability Management for Oracle Databases Guide

dbdst_classify(1M), dbdst_admin(1M), dbdst_convert(1M), dbdst_file_move(1M), dbdst_partition_move(1M), dbdst_preset_policy(1M), dbdst_report(1M), dbdst_rmvol(1M), dbdst_show_fs(1M), dbdst_tbs_move(1M), dbdst_obj_move(1M), dbdst_obj_view(1M), oracle_edition(7)

Veritas Storage Foundation: Storage and Availability Management for Oracle Databases