Free space on server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Free space on server

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    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.

  2. #2
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    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.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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]
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width