11-25-03, 15:24 #1Registered User
- Join Date
- Nov 2003
Unanswered: pleaseeeeeeeeeee help me with Linux
I have Oracle db on Linux server and we can see my /usr and /var are maxing out. I have most of my tablespaces under these two. I think but i am not sure if I can get space from /home and add it to /var or /usr. please let me know if I can do that and if yes...HOW??
PLEASEEEEEEEEE be specific with the answer cause I am not very good with Linux.
# df -k
Filesystem kbytes used avail capacity Mounted on
/dev/dsk/c0t0d0s0 1375228 418133 902086 32% /
/dev/dsk/c0t0d0s6 5164116 4520235 592240 89% /usr
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
mnttab 0 0 0 0% /etc/mnttab
/dev/dsk/c0t0d0s7 1572071 1404836 104353 94% /var
swap 140432 24140408 1% /var/run
swap 140832 424140408 1% /tmp
/dev/md/dsk/d0 17037887 6851709 10015800 41% /home
Pleaseeeeeeeeeeeeeeeee HelpPleaseeeeeeeeeeeeeeeee Help
11-25-03, 15:48 #2Registered User
- Join Date
- Jul 2003
please read my PM I sent you.
I am suggesting using the 10gig on the /home filesystem and creating a tablespace there. Then rebuild all of your indexes onto that tablespace that currently reside in your INDX tablespace.
Once the rebuild os totally done, then you could drop your INDX tablespace/datafile.
Eventually you could move other datafiles over if you wish.
Indexes always seem to be large space-hogs (perhaps use compress when creating indexes?)- The_Duck
you can lead someone to something but they will never learn anything ...