Home > Veritas Storage Foundation™ for Oracle Manual Pages
DBED_ANALYZER (1M) |
Maintenance Commands |
-o sort=tbs [\fp -f file | -t tablespace ] -o sort=table [\fp -f file | -t table ] -o sort=disk [\fp -f file | -t tablespace ]
pkginfo -l VRTSdbed
The dbed_analyzer command provides table,tablespace-to-physical disk mapping information for all the datafiles in a specified table,tablespace, list of table,tablespaces, or an entire database. In addition, dbed_analyzer provides information about the amount of disk space they are using.
$ /opt/VRTSdbed/bin/dbed_analyzer -S PROD -H /usr1/oracle -o sort=tbs -t SYSTEM TBSNAME DATAFILE DEVICE SIZE(sectors) SYSTEM /usr1/oracle/rw/DATA/prod.dbf c3t21000020379DBD5Fd0 819216
This example shows how to obtain storage mapping information sorted by disk for a specified tablespace:
$ /opt/VRTSdbed/bin/dbed_analyzer -S PROD -H /usr1/oracle -o sort=disk -t SYSTEM DEVICE TBSNAME DATAFILE SIZE(sectors) c3t21000020379DBD5Fd0 SYSTEM /usr1/oracle/rw/DATA/prod.dbf 819216
This example shows how to obtain storage mapping information sorted by disk for a list of tablespaces:
$ /opt/VRTSdbed/bin/dbed_analyzer -S PROD -H /usr1/oracle -o sort=disk -f /tmp/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
This example shows how to obtain storage mapping information for a specified table:
$ /opt/VRTSdbed/bin/dbed_analyzer -S $ORACLE_SID -H $ORACLE_HOME -o sort=table -t EMP TABLENAME DATAFILE DEVICE SIZE(sectors) EMP /oradata/emp01.dbf c2t12d0 800 /oradata/emp02.dbf c2t12d0 345904 /oradata/emp03.dbf c2t14d0 789560 \fp
This example shows how to obtain storage mapping information for a list of tables:
$ /opt/VRTSdbed/bin/dbed_analyzer -S $ORACLE_SID -H $ORACLE_HOME -o sort=table -f /tmp/tablefile TABLENAME DATAFILE DEVICE SIZE(sectors) EMP /usr1/oracle/rw/DATA/prod.dbf c3t21000020379DBD5Fd0 819216 PAYROLL /usr1/oracle/rw/DATA/pemp_20000 c3t21000020379DBD5Fd0 1021968 TEMP /usr1/oracle/rw/DATA/pemp_20001 c3t21000020379DBD5Fd0 2048016 ADMIN /usr1/oracle/rw/DATA/prodaux.dbf c3t21000020379DBD5Fd0 819216 \fp
This example shows how to obtain storage mapping information sorted by tablespace for a list of tablespaces:
$ /opt/VRTSdbed/bin/dbed_analyzer -S PROD -H /usr1/oracle -o sort=tbs -f /tmp/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 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
Veritas Storage Foundation for Oracle Administrator's Guide Veritas Storage Foundation for Oracle RAC Installation and Configuration Guide ~
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.