Getting blocking / waiting sessions info.

From: Sunil <psunil_at_my-deja.com>
Date: 2000/07/11
Message-ID: <8kg30j$85o$1@nnrp1.deja.com>#1/1

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.deja.com/
Before you buy. Received on Tue Jul 11 2000 - 00:00:00 CDT