Home » RDBMS Server » Performance Tuning » Investigating sudden Temp Tablespace growth from AWR? (Oracle 10.2.0.4)
Investigating sudden Temp Tablespace growth from AWR? [message #559571] Wed, 04 July 2012 05:24
orapratap
Messages: 113
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

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


Current Time: Sun Apr 20 05:12:27 CDT 2014

Total time taken to generate the page: 0.24920 seconds