This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

TEMP tablespace ran out of space, can SQL PI help?

Last night the TEMP tablespace maxed out on one of your databases:

ORA-1652: unable to extend temp segment by 64 in tablespace TEMP

It almost doubled in size to 8GB in a matter of minutes. I was trying to use SQL PI to find out what happened and if there is anything that I need to do to stop it happening again. But I can't seem to find anything in SQL PI that correlates with this event. Can SQL PI help me understand this better?

Thanks,

Kris

Parents
  • Hi Kris, 

    After applying John's suggestion in order to narrow down the time range then, 

    In the performance tree select

    Instance -> Files -> select your tempDB file -> expand to see the SQL Statements that generated the most TEMP Reads/Writes for this temp file.

    Regards

    George

  • Thanks All!

    That did help :-) There is so much hidden in here!

    I was able to find the culprit by using the Files -> TempFile tree that George suggested and as shown in the screenshot. Perfect!

    Cheers,

    Kris

Reply Children
No Data