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.