Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Temp usage history

676589Jan 9 2009 — edited Jan 9 2009

Hi guys,

im running in a little problem.

This morning one client gave me an "ORA-1652: unable to extend temp segment by 128 in tablespace TEMP" error in oralce log file.

I have a query that can detect the oracle temp usage and by whom but at this current moment, but for that i need to detect the problem before it happens ( in some cases i can do it, in other cases i can't like this one ).

My question is:

Is it possible now, that 5 hours have passed since the error i can check wich process/sid/user/query has exploded TEMP at that time ? Maybe in history but i cant find anything that helps on that.

Helder

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2009

Added on Jan 9 2009

#general-database-discussions

5 comments

7,517 views