deallocate unused
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: deallocate unused

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Question

    the following document [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem2a.htm#2056065
    states:
    You can free only unused space above the high water mark (that is, the point beyond which database blocks have not yet been formatted to receive data).
    I always had an impression that deallocated unused will free up a space below hight water mark.
    According to the document located at the link above 'deallocate unused' does not re-gain anything below the hight water mark...
    Please help me to understand this issue...

  2. #2
    Join Date
    Aug 2000
    Posts
    163
    this is a correct link:
    [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem2a.htm#2056065[/url]

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The high water mark is the upper limit on the data you have put in the table. When you delete data, the highwater mark does not get adjusted back down. Once these blocks have data in them they are no longer UNUSED. When you delete the data, the blocks may be empty, but they are not UNUSED.

    There are only two ways to modify the highwater mark, TRUNCATE TABLE and MOVE TABLE.

    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."

  4. #4
    Join Date
    Aug 2000
    Posts
    163
    Thank you Jeff.
    Would you be kind enough to let me know what is it that 'deallocate unused' is de-allocating. What would represent that 'unused' part?
    Thank you beforehand.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    imagine you have a segment with 5 extents allocated however only 4 and half are used (so the high water mark would be the mark in 4.5 extents) the other half would be freed if you deallocate manually.

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