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: 131
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: Tue Oct 06 22:26:02 CDT 2015

Total time taken to generate the page: 0.10607 seconds