VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using VxDBA to Perform Administrative Operations Prerelease 8 September 2005, 8:55am
382 VERITAS Storage Foundation for Oracle Administrator’s Guide
Display Oracle Tablespace/Datafile Space Usage displays a screen similar to the following:
---------------------------------------------------------------
VxDBA: Display OracleTablespace/Datafile Space Usage - PROD
---------------------------------------------------------------
ORACLE_SID
: PROD
ORACLE_HOME : /usr1/oracle
Database Status : ONLINE
# File Systems : 1
# Tablespaces : 4
# Datafiles : 4
TABLESPACE TOT_MB TOT_BLKS MB_FREE BLKS_FREE
---------- ------ -------- ------ --------
SYSTEM 5033 2457600 740 361340
TSTAB 52 25600 52 25579
TSIDX 1000 510976 987 504320
TSTMP 538 274432 436 222208
4 rows selected.
Press <Return> to continue...
or <q> to skip...
TABLES FILENAME MB_FRE BLK_FRE CAN_USE CAN_NOT TOT_BLKS
------ ----------------- ------ ------- ------- ------- --------
SYSTEM /db01/PROD/sys1 740 361340 361335 5 2457600
TSTAB /db01/PROD/tstab 52 25579 25579 0 25600
TSIDX /db01/PROD/tsidx 1000 504320 504320 0 510976
TSTMP /db01/PROD/tstmp 538 222208 222208 0 274432
4 rows selected.
Press <Return> to continue...