control file,datafiles...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: control file,datafiles...

  1. #1
    Join Date
    Feb 2003
    Posts
    69

    control file,datafiles...

    hi all,

    I would like to calculate the size of control file and datafiles for each tablespace...is any one help me..

    b'coz i am working on unix box, server is in US. Oracle version is 8i. How to check free space and used space on unix box from my client mechine ?
    HTML

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Check out the scripts section of dbasupport.com http://www.dbasupport.com/oracle/scr...nt/Management/

    HTH.

  3. #3
    Join Date
    Feb 2003
    Posts
    69
    ggnaraj,

    do you have any solution to find the free space availabilty and used space on unix box ?

    b'coz my server is in US. just i connected and trying to clculate the sizes of files. in addition i need to available space on my unix box. can you help me out..please..
    HTML

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by seshib
    ggnaraj,

    do you have any solution to find the free space availabilty and used space on unix box ?

    b'coz my server is in US. just i connected and trying to clculate the sizes of files. in addition i need to available space on my unix box. can you help me out..please..
    Your previous post showed that you have run out of disk space for your oracle partitions. To add more space ask your sys admin of the unix box who is responsible for the same. He should be able to add another harddisk or add more space to your oracle partitions.

    BTW, you should be able to check if all your tablespaces are using the space allocated to them, if not, resize the datafiles accordingly. This should free space immediately for you at the OS level. So also, check if you are having archivelogs on the oracle partitions. If so, ask the sys admin to move to tapes and delete them to free up space.

    HTH.

  5. #5
    Join Date
    Feb 2003
    Posts
    69
    databse is noarchive log mode..

    just go though this...

    Filesystem kbytes used avail capacity Mounted on
    /dev/dsk/c0t0d0s0 4129290 1849798 2238200 46% /
    /proc 0 0 0 0% /proc
    fd 0 0 0 0% /dev/fd
    mnttab 0 0 0 0% /etc/mnttab
    swap 1136296 24 1136272 1% /var/run
    swap 1283360 147088 1136272 12% /tmp
    /dev/md/dsk/d6 70562950 42135811 27721510 61% /home
    /dev/md/dsk/d1 34993271 34162496 480843 99% /oradata01
    /dev/md/dsk/d2 8171922 2194639 5895564 28% /common
    /dev/md/dsk/d5 35009161 19483415 15175655 57% /addappl
    /dev/md/dsk/d4 35009161 34659071 0 100% /oradata02
    /dev/md/dsk/d0 53566120 15810285 37220174 30% /home/dbdump

    This is the position...i have to create space on this...
    HTML

  6. #6
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Use the following script to know the free space ... http://www.dbasupport.com/oracle/scr...iled/84.shtml.

    Now, use ALTER DATABASE DATAFILE '...' RESIZE command to get some free space.

    Originally posted by seshib
    databse is noarchive log mode..
    Well, you don't need to worry about archivelogs then!

    Originally posted by seshib

    Filesystem kbytes used avail capacity Mounted on
    /dev/dsk/c0t0d0s0 4129290 1849798 2238200 46% /
    /proc 0 0 0 0% /proc
    fd 0 0 0 0% /dev/fd
    mnttab 0 0 0 0% /etc/mnttab
    swap 1136296 24 1136272 1% /var/run
    swap 1283360 147088 1136272 12% /tmp
    /dev/md/dsk/d6 70562950 42135811 27721510 61% /home
    /dev/md/dsk/d1 34993271 34162496 480843 99% /oradata01
    /dev/md/dsk/d2 8171922 2194639 5895564 28% /common
    /dev/md/dsk/d5 35009161 19483415 15175655 57% /addappl
    /dev/md/dsk/d4 35009161 34659071 0 100% /oradata02
    /dev/md/dsk/d0 53566120 15810285 37220174 30% /home/dbdump

    This is the position...i have to create space on this...
    If you have root access on the unix box, then go ahead and do the needful using the volume manager.

    HTH.

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