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

ManualsBrandsHP ManualsSoftwareHP-UX 11i Volume Management (LVM/VxVM) Software

131

132

133

134

135

136

137

138

139

140

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,

$ /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:

DEVICE TBSNAME DATAFILE SIZE(sectors)

c3t21000020379DBD5Fd0 SYSTEM /usr1/oracle/rw/DATA/PROD.dbf 819216

c3t21000020379DBD5Fd0 TEMP /usr1/oracle/rw/DATA/temp_20000 1021968

c3t21000020379DBD5Fd0 TEMP /usr1/oracle/rw/DATA/temp_20001 2048016

c3t21000020379DBD5Fd0 SYSAUX /usr1/oracle/rw/DATA/sysaux.dbf 819216

c3t21000020379DBD5Fd0 ITEM /usr1/oracle/rw/DATA/item_1000 1021968

c3t21000020379DBD5Fd0 ITM_IDX /usr1/oracle/rw/DATA/itm_idx_2000 1021968

c3t21000020379DBD5Fd0 PRODID_IDX /usr1/oracle/rw/DATA/prodid_idx_3000 1021968

c3t21000020379DBD5Fd0 QTY_IDX /usr1/oracle/rw/DATA/qty_idx_7000 1021968

c3t21000020379DBD5Fd0 ROLL_1 /usr1/oracle/rw/DATA/roll_1_5000 1021968

c3t21000020379DBD5Fd0 ROLL_2 /usr1/oracle/rw/DATA/roll_2_6000 1021968

c3t21000020379DBD5Fd0 ORDERS /usr1/oracle/rw/DATA/orders_4000 1021968

c3t21000020379DBD5Fd0 ORD_IDX /usr1/oracle/rw/DATA/ord_idx_10000 1021968

c3t21000020379DBD5Fd0 QTY_IDX /usr1/oracle/rw/DATA/qty_idx_7001 1024016

c3t21000020379DBD5Fd0 ITM_IDX /usr1/oracle/rw/DATA/itm_idx_2001 1024016

c3t21000020379DBD5Fd0 ROLL_1 /usr1/oracle/rw/DATA/roll_1_5001 1024016

c3t21000020379DBD5Fd0 QTY_IDX /usr1/oracle/rw/DATA/qty_idx_7002 1024016

c3t21000020379DBD5Fd0 ROLL_2 /usr1/oracle/rw/DATA/roll_2_6001 1024016

c3t21000020379DBD5Fd0 ITEM /usr1/oracle/rw/DATA/item_1001 4096016

143Using Storage Mapping

Using dbed_analyzer