Investigating sudden Temp Tablespace growth from AWR? [message #559571] |
Wed, 04 July 2012 05:24 |
|
orapratap
Messages: 134 Registered: November 2011 Location: Canada
|
Senior Member |
|
|
Hello
In one of our client application system, temp tablespace grew by 2-3 gb during a batch process
Is it possible to know the reason by looking at the AWR alone?
Please find the PGA memory and Temp tablespace details as captured in the AWR
Apparently the memory usage seems no issue to me 9at least) and I suspect it might be some insert into temp tables which might have caused this growth in temp tablepsace, however such inserts aren't captured in the AWR as may not be suitable candidate in individual execution
Regards
Orapratap
|
|
|