Home > Veritas Storage Foundation™ for Oracle Manual Pages

DBED_ANALYZER (1)

User Commands

Table of contents


NAME

dbed_analyzer - retrieves tablespace-to-physical-disk mapping information for all the datafiles in a specified database. It also provides information about the amount of disk space being used by a tablespace. it can also retrieve table-to-physical-disk mapping information for a given table or for a list of tables in a specified database.It also provides information about the amount of disk space being used by a table or list of tables.

SYNOPSIS

dbed_analyzer -S ORACLE_SID -H ORACLE_HOME

     -o sort=tbs   [\fp -f file | -t tablespace ]
     -o sort=table [\fp -f file | -t table ]
     -o sort=disk  [\fp -f file | -t tablespace ]


AVAILABILITY

Veritas Storage Foundation for Oracle. To determine whether this product is installed on an \1 system, enter:

lslpp -L VRTSdbed


DESCRIPTION

Effectively performing a parallel backup requires an understanding of which table or tablespaces reside on which disks. If two table or tablespaces reside on the same disk, for example, backing them up in parallel will not reduce their down time.

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.


OPTIONS

The following options are supported:
-S ORACLE_SID
Specifies the name of the Oracle database.
-H ORACLE_HOME
Specifies the ORACLE_HOME setting for the ORACLE_SID database.
-o sort=tbs
Provides the layout of the specified tablespaces on the physical disk as well as the amount of disk space they are using.
-o sort=table
Provides the layout of the specified table on the physical disk as well as the amount of disk space they are using.
-o sort=disk
Provides the name of the disks containing the specified tablespaces as well as the amount of disk space the tablespaces are using.
-f filename
Specifies the name of the file containing a list of the tablespaces for which to obtain mapping information.
-t tablespace
Specifies the name of the tablespace for which to obtain mapping information.
-t table
Specifies the name of the table for which to obtain mapping information.


EXAMPLES

This example shows how to obtain storage mapping information sorted by tablespace for a specified tablespace:

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


NOTES

If -f filename and -t tablespace are not specified then all the tablespaces in the database will be analyzed.

SEE ALSO

dbed_ckptdisplay(1M), dbed_ckptmount(1M), dbed_ckptplan(1M), dbed_ckptpolicy(1M), dbed_ckptquota(1M), dbed_ckptremove(1M), dbed_ckptrollback(1M), dbed_ckptumount(1M), dbed_clonedb(1M), dbed_update(1M), oracle_edition(7)

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.