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

Top Replies

Parents

0 george.avramis over 5 years ago

Use PI to find out what queries were running at that time and check which one could be the culprit by checking what actions each one performs.
Cancel
Up 0 Down

Cancel

Reply

0 george.avramis over 5 years ago

Use PI to find out what queries were running at that time and check which one could be the culprit by checking what actions each one performs.
Cancel
Up 0 Down

Cancel

Children

No Data