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: 132
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: Mon May 30 04:46:12 CDT 2016

Total time taken to generate the page: 0.29171 seconds