Home » RDBMS Server » Performance Tuning » Investigating sudden Temp Tablespace growth from AWR? (Oracle
Investigating sudden Temp Tablespace growth from AWR? [message #559571] Wed, 04 July 2012 05:24
Messages: 134
Registered: November 2011
Location: Canada
Senior Member

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


Previous Topic: use_hash hint without arguments
Next Topic: How to find out who is the locking SQL statement?
Goto Forum:

Current Time: Fri Oct 28 15:28:27 CDT 2016

Total time taken to generate the page: 0.31188 seconds