Free space on server

Hi all,

How do I find out how much space on my Oracle server
is free ??
I am running Oracle on a Solaris server.

Thanks,
Shiva.

I know there is no direct way of achieving it, but is there no command which would even give a description of the amount of space allocated to each file and the used up space for each??

Shiva.

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.

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

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]