TEMP usage history [message #466345] |
Mon, 19 July 2010 02:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Hi ,
My stats jobs failed last night with "ORA-01652 :Unable to extend TEMP" error.
Is there any way to check this history data, what other session was using TEMP tablespace extensively ?
thanks
|
|
|
|
Re: TEMP usage history [message #466348 is a reply to message #466347] |
Mon, 19 July 2010 02:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Hi Rahul, this is first time it failed with TEMP issue.
There must be some user query thta might have used lot of TEMP segments) i would like to point out this to the user so that this
wouldnt happen again.
I dont know where to look for this history information.
|
|
|
|
|
Re: TEMP usage history [message #486095 is a reply to message #466345] |
Mon, 13 December 2010 10:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
i found it realy difficult , as my stats job runs for 8 hours.Is there a way to get TEMP usage statistics over a period of time,by session/sqlid ?
|
|
|
Re: TEMP usage history [message #486104 is a reply to message #486095] |
Mon, 13 December 2010 10:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Is there a way to get TEMP usage statistics over a period of time,by session/sqlid ?
You can join DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_SQL_PLAN and get SESSION_ID and TEMP_SPACE columns... if you have purchased the option to use these views.
Regards
Michel
|
|
|