Home » RDBMS Server » Performance Tuning » temp tablespace stats (oracle
temp tablespace stats [message #364473] Mon, 08 December 2008 15:05 Go to next message
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?
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: 65088
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.

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

Current Time: Wed Jul 26 15:55:42 CDT 2017

Total time taken to generate the page: 0.22106 seconds