HWM for temporary tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: HWM for temporary tablespace

  1. #1
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49

    HWM for temporary tablespace

    Hi,

    I have a temporary tablespace that has a high number of HWM blocks (1470). Is there any way i can remove these blocks like those in data tables using commands like "alter table my_table deallocate unused" ?
    thanks.
    Regards
    CF

  2. #2
    Hi,
    I think you can just ignore it.Oracle will remove these extents when you shutdown . And these used extents can be reused by other sessions when needed, so that oracle do not need to allocate and deallocate everytime some sessoin need disk sort

    0
    www.cnoug.org

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