Printable View
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 ?
Check out the scripts section of dbasupport.com http://www.dbasupport.com/oracle/scr...nt/Management/
HTH.
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.Quote:
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..
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.
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...
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.
Well, you don't need to worry about archivelogs then!Quote:
Originally posted by seshib
databse is noarchive log mode..
If you have root access on the unix box, then go ahead and do the needful using the volume manager.Quote:
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...
HTH.