Home » RDBMS Server » Performance Tuning » temp tablespace stats (oracle 8.1.7.3)
temp tablespace stats [message #364473] Mon, 08 December 2008 15:05 Go to next message
Georgette
Messages: 3
Registered: November 2008
Junior Member
We are seeing extremely high temp tablespace read/writes (on a ESTAT/BSTAT) report. I'm trying to figure out what process is causing this. Noticed a few tables (V$SORT_USAGE, V$SESSTAT, etc...) but they are empty. Does anyone know what process populates these tables? or does anyone have any suggestions on how to gets detailed stats on the temp tablespaces?
Thanks.
Re: temp tablespace stats [message #364508 is a reply to message #364473] Mon, 08 December 2008 22:59 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First you should use Statspack instead of bstat/estat you will get much more and useful information.

Then v$ views are dynamic ones so show you what happpens now but if you follow these views (v$sort_usage and v$session, sort and direct reads/wirtes statistics) you should be able to see which sessions use temp tablespace then which SQL statements.

Regards
Michel
Previous Topic: INDEX_DESC Hint
Next Topic: Advice on SQL tuning
Goto Forum:
  


Current Time: Sat Dec 10 16:33:23 CST 2016

Total time taken to generate the page: 0.07283 seconds