| temp tablespace stats [message #364473] |
Mon, 08 December 2008 15:05  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
