Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: Space in lvol on HP server for db

    Hi

    I freed 15GB from a logical volume on the HPUX server by removing a tablespace after moving the data in its datafiles to another lvol which was successful and rebuilt the indexes.

    Can still access the data.

    But cannot see a reduction in the 'used space' % in /OPTD. It is still 97%

    15GB is about 9% so doing bdf or df -k should show the used space for /OPTD as 88%. Am I wrong?

    Actually /OPTD is in lvol1.

  2. #2
    Join Date
    Aug 2008
    Posts
    464
    Just thought I'd also ask if this has got something to do with the bounce size of the filesystem?

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What does lsof report about files in question?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Aug 2008
    Posts
    464
    Does lsof have to be run as root because I issued

    lsof -u oracle

    and it said command not found. Or does it have to be downloaded?

    The alert log shows that the files associated to the dropped tablespace have been deleted.

    So if the files have been deleted then surely something is stuck somewhere.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I am sorry to see that GOOGLE is broken for you.
    Please wait while repairs are completed.
    Additional details will be posted when they become available.
    If you get bored, you can restart the DB and/or the OS.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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