TEMP TABLESPACE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TEMP TABLESPACE

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    Question

    I have 1000M TEMP TABLESPACE which is 99% full for last couple weeks...my question is can I leave it like this or do I need to clean this up?...how do I free temp tablespace?...

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Leave it. The fact that you reached 99% may indicate you need more TEMP.
    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
    Feb 2001
    Location
    Paris, France
    Posts
    809
    1) if you run Oracle 8, then the behaviour is normal, the tablespace is filled, and then Oracle manages to free temp segments when space is needed ... but sometimes it tells you that TEMP tablespace is full, well I never understood this kind of bug :/
    well anyway, if you do not have problems saying 'unable to extent ... segment in TEMP tablespace', then it works fine.

    2) if you still want to free space :

    alter tablespace TEMP default storage (pctincrease 1);
    alter tablespace TEMP default storage (pctincrease 0);
    alter tablespace TEMP coalesce;

    this will free all unused segments in your TEMP tablespace

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    If you are sure that 1000M TEMP ts is enough for you, it will be good to have it cleaned up sometime - the next scheduled downtime on your system.

    If you are seeing space related errors in your alert log, you either need to add a datafile or clean-up TEMP segments.

    Some processes that get terminated abnormally (may be because killed), leave these segments in TEMP ts.

    svk

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