Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Investigating I/O Performance for SG Oracle RAC: Storage Mapping
Using dbed_analyzer
Chapter 6
126
SYSAUX/usr1/oracle/rw/DATA/sysaux.dbfc3t21000020379DBD5Fd0819216
ITEM/usr1/oracle/rw/DATA/item_1000c3t21000020379DBD5Fd01021968
ITM_IDX/usr1/oracle/rw/DATA/itm_idx_2000c3t21000020379DBD5Fd0
1021968
PRODID_IDX/usr1/oracle/rw/DATA/prodid_idx_3000
c3t21000020379DBD5Fd0
1021968
QTY_IDX/usr1/oracle/rw/DATA/qty_idx_7000c3t21000020379DBD5Fd0
1021968
ROLL_1/usr1/oracle/rw/DATA/roll_1_5000c3t21000020379DBD5Fd0
1021968
ROLL_2/usr1/oracle/rw/DATA/roll_2_6000c3t21000020379DBD5Fd0
1021968
ORDERS/usr1/oracle/rw/DATA/orders_4000c3t21000020379DBD5Fd0
1021968
ORD_IDX/usr1/oracle/rw/DATA/ord_idx_10000c3t21000020379DBD5Fd0
1021968
QTY_IDX/usr1/oracle/rw/DATA/qty_idx_7001c3t21000020379DBD5Fd0
1024016
ITM_IDX/usr1/oracle/rw/DATA/itm_idx_2001c3t21000020379DBD5Fd0
1024016
ROLL_1/usr1/oracle/rw/DATA/roll_1_5001c3t21000020379DBD5Fd0
1024016
QTY_IDX/usr1/oracle/rw/DATA/qty_idx_7002c3t21000020379DBD5Fd0
1024016
ROLL_2/usr1/oracle/rw/DATA/roll_2_6001c3t21000020379DBD5Fd0
1024016
ITEM/usr1/oracle/rw/DATA/item_1001c3t21000020379DBD5Fd04096016
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,
$ /opt/VRTSdbed/bin/dbed_analyzer -S PROD -H /usr1/oracle \
-o sort=disk -f /tmp/tbsfile
Output similar to the following is displayed in the file tbsfile:
DEVICETBSNAMEDATAFILESIZE(sectors)
c3t21000020379DBD5Fd0SYSTEM/usr1/oracle/rw/DATA/PROD.dbf819216
c3t21000020379DBD5Fd0TEMP/usr1/oracle/rw/DATA/temp_200001021968
c3t21000020379DBD5Fd0TEMP/usr1/oracle/rw/DATA/temp_200012048016
c3t21000020379DBD5Fd0SYSAUX/usr1/oracle/rw/DATA/sysaux.dbf819216
c3t21000020379DBD5Fd0ITEM/usr1/oracle/rw/DATA/item_10001021968
c3t21000020379DBD5Fd0ITM_IDX/usr1/oracle/rw/DATA/itm_idx_2000
1021968
c3t21000020379DBD5Fd0PRODID_IDX
/usr1/oracle/rw/DATA/prodid_idx_30001021968
c3t21000020379DBD5Fd0QTY_IDX/usr1/oracle/rw/DATA/qty_idx_7000
1021968