temp tablespace stats [message #364473] |
Mon, 08 December 2008 15:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 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
|
|
|