deleted file size didn't update the available O.S. disk space
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: deleted file size didn't update the available O.S. disk space

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    deleted file size didn't update the available O.S. disk space

    SOLARIS 8
    ORACLE 8.1.6

    I have this weird scenario,
    I have drop a tablespace that is used by an RBS. I intend to recreate a bigger TABLESPACE for a bigger RBS.

    After I drop the tablespace, I issue
    the command in o.s.:
    rm RBSbig01.dbf

    the command was successful because it didn't feedback any error.
    but to my surprise, the 500M size of that file didn't reflect the AVAILABLE size as i issue a
    df -k

    it was still the same before I remove the datafile.

    Any experience of such kind guys, pls share, as again I am very much short of resource the only remaining file system that I can use is the one where ARCHiving resides?


    Thanks in advance.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well I know in Tru64 or HP-UX it takes sometime to free the space at OS level however I am not aware of this behavious on Sun Solaris

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    thanks for your response PANDO,
    If I can only restart the server itself to accomdodate my needs then I could have done it now, to confirm also your explanation.
    But the server is in 24X7, so may have to wait for a little while and hoping that HP-UX shares the same behaviour.

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    you got it right PANDO,
    I've waited for at least an hour and now the avail size of the disk space was updated. THANKS alot.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by reydp
    I've waited for at least an hour and now the avail size of the disk space was updated.
    This sucks aint it?? in this respect Windows is good
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by abhaysk
    This sucks aint it?? in this respect Windows is good
    Hey Jeff! Did you see that? Hey Jeff, Jeff! DID YOU SEE THAT?

  7. #7
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by abhaysk
    This sucks aint it?? in this respect Windows is good
    In a way yes ,
    but I'm not sure if the behaviour is still the same with verion 9
    And yet, who among us will prefer using Windows in return to UNIX?

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by reydp
    And yet, who among us will prefer using Windows in return to UNIX?
    dam our customers .. they do ..

    PS we have some DB servers 2 to 3 TB on Windows .. ( Jeff are you seeing this post? )
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  9. #9
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by abhaysk
    [B
    PS we have some DB servers 2 to 3 TB on Windows .. ( Jeff are you seeing this post? ) [/B]
    Nahhh...
    maybe 10 year from now they could.

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by abhaysk
    dam our customers .. they do ..

    PS we have some DB servers 2 to 3 TB on Windows .. ( Jeff are you seeing this post? )
    You can pull a 34' camper with a Honda Civic. That doesn't make it the smart thing to do.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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