Foglight

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
No Data
Reply Children