Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

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:
TABLESPACE 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
ROLL_1 /usr1/oracle/rw/DATA/roll_1_5000 c3t21000020379DBD5Fd0 1021968
ROLL_2 /usr1/oracle/rw/DATA/roll_2_6000 c3t21000020379DBD5Fd0 1021968
ORDERS /usr1/oracle/rw/DATA/orders_4000 c3t21000020379DBD5Fd0 1021968
ORD_IDX /usr1/oracle/rw/DATA/ord_idx_10000 c3t21000020379DBD5Fd0 1021968
QTY_IDX /usr1/oracle/rw/DATA/qty_idx_7001 c3t21000020379DBD5Fd0 1024016
ITM_IDX /usr1/oracle/rw/DATA/itm_idx_2001 c3t21000020379DBD5Fd0 1024016
ROLL_1 /usr1/oracle/rw/DATA/roll_1_5001 c3t21000020379DBD5Fd0 1024016
QTY_IDX /usr1/oracle/rw/DATA/qty_idx_7002 c3t21000020379DBD5Fd0 1024016
ROLL_2 /usr1/oracle/rw/DATA/roll_2_6001 c3t21000020379DBD5Fd0 1024016
ITEM /usr1/oracle/rw/DATA/item_1001 c3t21000020379DBD5Fd0 4096016
To obtain Storage Mapping information sorted by disk
◆
Use the dbed_analyzer command with the -f filename and -o sort=disk
options:
$ /opt/VRTSdbed/bin/dbed_analyzer -S $ORACLE_SID -H $ORACLE_HOME \
-o sort=disk -f filename
For example,
141Using Storage Mapping
Using dbed_analyzer