Locally Managed TEMP tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Locally Managed TEMP tablespace

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    Lightbulb Locally Managed TEMP tablespace

    Oracle 817 (64-bit) on Solaris8.

    We have created a locally managed temporay tablespace using TEMPFILE option of the size 2GB. It seems to be atlest 95% utilized all the time and SMON not seems to be cleaning up.

    As you know on temporary tablespaces, we can not run ALTER TABLESPACE TEMP coalesce.

    What could be the reason why SMON is not cleaning up/coalescing periodically? Is there any setting or command that I use to see that the TEMP tablespace is coalesced and freed up?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This is a basic concept that people just don't seem to understand. TEMPORARY tablespace doesn't get de-allocated, it gets reused.
    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."

  3. #3
    Join Date
    Sep 2000
    Posts
    155
    Thanks Jeff!
    I do understand that it gets recycled or reused.
    However, I was curious to know if there is a way
    to do this with TEMP tablespace.

    Thanks again!

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you understand it gets reused, why would you think it needs to be coalesced?
    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."

  5. #5
    Join Date
    Sep 2000
    Posts
    155
    Perhaps, I thought there would be a way to coalesce TEMP tablespaces
    like the option we have with NON-TEMP tablespaces.

    Anyway, lets end the discussion here.
    Thanks for your clarification!

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well LOCALLY MANAGED TEMPORARY TABLESPACE uses uniform size extents, if these extents are reused then there is no point coalescing a tablespace, all space is reused over and over again

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