Getting blocking / waiting sessions info. 
Author Message
 Getting blocking / waiting sessions info.

I want to get session statistics and I have script for that.
However, the SQL used for getting blocking sessions and waiting
sessions per sid takes lot of time to execute, especially the second
one.
SQL stmts I use for this are :
1. select count(*) from dba_waiters group by holding_sessions;
2. select count(*) from dba_waiters group by waiting_sessions;

Could anybody please tell me why it's taking long time.
If this table is not the correct one to get this information, which
tables should I use to get this information.

Thanks in advance,
Sunil.

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Getting blocking / waiting sessions info

2. q: buffer busy wait(data block wait) when P3=130

3. Blocking processes - getting some info

4. Wait Message during block execute

5. hot block..buffer busy waits.. questions

6. buffer busy waits for data block

7. Wait for credit - send blocked

8. high data block waits in v$waitstat 8.1.7

9. Trace SQL in a session with bind and wait events 8i

10. Total wait time per session incurred by SQL locks

11. i/o waits by session?

12. Session is waiting for long....


 
Powered by phpBB® Forum Software