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

table/index extent resides. The reports provide information for 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
such as a table or an 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 the offset
and length information to the File System low level SmartTier commands to get
the exact location of the extent blocks.
Usage for dbdst_obj_view
dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME -t table [-s start_extent] [-e end_extent]
dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME -i index [-s start_extent] [-e end_extent]
dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME -p partition [-s start_extent] [-e end_extent]
dbdst_obj_view -S ORACLE_SID -H ORACLE_HOME -f datafile
■ The database must be online.
■ The command must be run as Oracle user.
Prerequisites
■ To make sure the SFDB repository is up-to-date, run
dbed_update at least once before using the command.
■ Generating a report for large tables will take long time.
■ To restrict the scope of the table/index, use start/end extents.
Notes
■ This command can be run on any node of an Oracle RAC cluster
on which the database is running.
For Oracle RAC
environments
Table 14-5 shows the sub-file report command options.
Table 14-5
dbdst_obj_view command options
DescriptionCommand option
Specifies the name of the Oracle database from
which information will be retrieved.
-S ORACLE_SID
Specifies the ORACLE_HOME for the database.-H ORACLE_HOME
This is an optional argument. If this option is
specified, a verification will be done after
moving each extent to target storage class. If
the target storage class does not have enough
free space, some of the table extents may not be
moved.
-v
265Configuring and administering SmartTier
Viewing SmartTier sub-file level reports