Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

To obtain storage mapping information sorted by disk
◆
Use the dbed_analyzer command with the -f filename and -o sort=disk
options:
$ /opt/VRTS/bin/dbed_analyzer -S $ORACLE_SID -H $ORACLE_HOME -o \
sort=disk -f filename
Output similar to the following is displayed in the file filename:
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
Defining database parameters for Database Dynamic Storage Tiering
using dbdst_admin
Running the dbdst_admin command defines parameters for the entire database.
You must run this command at least once to define the database parameters for
Database Dynamic Storage Tiering. Three pre-defined storage classes will be
created (PRIMARY, SECONDARY, and BALANCE). Parameter values are stored in
the SFDB repository.
Set at least one of the parameters in maxclass, minclass, statinterval,
sweeptime, sweepinterval, purgetime, or purgeinterval, to enable default values.
Add at least one class to enable the default classes.
Before defining your database parameteres using the dbdst_admin command,
review the following information:
377Veritas Storage Foundation for Oracle Command Line Interface
About the command line interface