Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: pleaseeeeeeeeeee help me with Linux

    Hi every1
    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 Help
    Pleaseeeeeeeeeeeeeeeee Help

  2. #2
    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 ...

Posting Permissions

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