Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

■ The -o sort=tbs option provides the layout of the specified
tablespaces on the physical disk as well as the amount of disk space
they are using.
■ The -o sort=disk option provides the name of the disks
containing the specified tablespaces as well as the amount of disk
space the tablespaces are using.
■ The -o sort=table option identifies the disk and the space
occupied on it by the specified table or list of tables.
■ The -f filename option specifies the name of a file containing
a list of the tables, tablespaces ro disk names for which to obtain
mapping information.
■ The -t option specifies the name of a specified tablespace (when
used with -o sort=tbs) or table (when used with -o
sort=table) for which to obtain mapping information.
■ If -f filename or -t tablespace is not specified then all the
tablespaces in the database will be analyzed.
■ For more information, see the dbed_analyzer(1M) online manual
page.
Usage notes
Obtaining Storage Mapping information for a list of tablespaces
To obtain Storage Mapping information sorted by tablespace
◆
Use the dbed_analyzer command with the -f filename and -o sort=tbs
options:
$ /opt/VRTSdbed/bin/dbed_analyzer -S $ORACLE_SID -H $ORACLE_HOME \
-o sort=tbs -f filename
For example,
$ /opt/VRTSdbed/bin/dbed_analyzer -S PROD -H /usr1/oracle \
-o sort=tbs -f /tmp/tbsfile
Output similar to the following is displayed in the file tbsfile:
TBSNAME DATAFILE DEVICE SIZE(sectors)
SYSTEM /usr1/oracle/rw/DATA/PROD.dbf c3t21000020379DBD5Fd0 819216
TEMP /usr1/oracle/rw/DATA/temp_20000 c3t21000020379DBD5Fd0 1021968
TEMP /usr1/oracle/rw/DATA/temp_20001 c3t21000020379DBD5Fd0 2048016
SYSAUX /usr1/oracle/rw/DATA/sysaux.dbf c3t21000020379DBD5Fd0 819216
ITEM /usr1/oracle/rw/DATA/item_1000 c3t21000020379DBD5Fd0 1021968
ITM_IDX /usr1/oracle/rw/DATA/itm_idx_2000 c3t21000020379DBD5Fd0 1021968
PRODID_IDX /usr1/oracle/rw/DATA/prodid_idx_3000 c3t21000020379DBD5Fd0 1021968
QTY_IDX /usr1/oracle/rw/DATA/qty_idx_7000 c3t21000020379DBD5Fd0 1021968
Using Storage Mapping
Using dbed_analyzer
142