On Unix server file systems you can use this command. If its on Oracle database level, you have to have some custom script (see the links)which gives total and used space. If you have enterprize Manager it shows up in the DBA studio component of OEM.

[url]http://dbasupport.com/oracle/scripts/Detailed/111.shtml[/url]
[url]http://dbasupport.com/oracle/scripts/Detailed/89.shtml[/url]

apps% df -k

Filesystem kbytes used avail capacity Mounted on
/dev/vx/dsk/rootvol 6050182 877955 5111726 15% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
/dev/vx/dsk/home 191611 5717 166733 4% /export/home
swap 3207192 17504 3189688 1% /tmp
/dev/dsk/c2t5d0s0 6019422 907089 5052139 16% /ven01
/dev/dsk/c2t5d0s1 3081231 100589 2949830 4% /ven02
/dev/dsk/c2t5d1s0 9117005 2218472 6807363 25% /oracle
/dev/dsk/c2t5d2s0 9117005 3009745 6016090 34% /oracle2
/dev/dsk/c2t5d3s0 9117005 3315351 5710484 37% /oracle3

[Edited by sreddy on 03-14-2001 at 04:28 PM]