Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

$ /opt/VRTS/bin/dbdst_show_fs -S $ORACLE_SID -m /oradata
For example:
$ /opt/VRTS/bin/dbdst_show_fs -S VRTS11r2 -m /data11r2 -o volume
VOLUME NAME SIZE USED AVAILABLE TAG
----------- ---- ---- --------- ---
datavol-b4vset 10240000 3585514 6654486 PRIMARY
datavol1 1024000 1024000 0 FAST
datavol2 4608000 2347872 2260128 MEDIUM
When the GOLD or SILVER tier requires more space, we could add extra space by
adding new volumes to the respective storage tier using the dbdst_addvol
command. For example:
$ /opt/VRTS/bin/dbdst_addvol -S $ORACLE_SID \
-M /dev/vx/dsk/oradg/ora_vset -v vol7:GOLD
As soon as you add a new volume, the SmartTier policy is enforced and the extents
are balanced over the new volume too. This can be viewed by using the
dbdst_show_fs command again.
To view detailed extent information about a given file, you can use the fsmap
command. For example:
$ /opt/VRTS/bin/fsmap -a /oradata/emp.dbf
$ fsmap -a /standby/oradata1_1/slave/system01.dbf |more
Volume Extent Type File Offset Extent Size File
vol1 Data 0 262144 /standby/oradata1_1/slave/system01.dbf
vol2 Data 262144 8192 /standby/oradata1_1/slave/system01.dbf
vol3 Data 270336 131072 /standby/oradata1_1/slave/system01.dbf
vol1 Data 401408 262144 /standby/oradata1_1/slave/system01.dbf
vol2 Data 663552 180224 /standby/oradata1_1/slave/system01.dbf
vol3 Data 843776 32768 /standby/oradata1_1/slave/system01.dbf
vol1 Data 876544 49152 /standby/oradata1_1/slave/system01.dbf
vol2 Data 925696 65536 /standby/oradata1_1/slave/system01.dbf
vol3 Data 991232 196608 /standby/oradata1_1/slave/system01.dbf
Viewing SmartTier sub-file level reports
Use the dbdst_obj_view command to get detailed specific database, index, or
partition information. The report indicates in which storage class each database
Configuring and administering SmartTier
Viewing SmartTier sub-file level reports
264