Re: Getting blocking / waiting sessions info

My application is generic, which runs on any Oracle version from 7.3.2 onwards. So far my query was working fine. But recently when checked particularly when Oracle was having lo of load, took lot of time. Even that time 3 sids were holding 28 locks.
I am not sure, if that was really too much load or not, but other queries were working fine.
Anyway I will try with the queries you provided.

In article <8kh8ha$344$1_at_nnrp1.deja.com>,   jeanch_at_my-deja.com wrote:
> In article <8kg3a7$89b$1_at_nnrp1.deja.com>,
> Sunil <psunil_at_my-deja.com> wrote:
> > 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.
> >
> I dunno which Oracle version you're using but on 8.0.4 you could run
> the following:
> 1.select count(*) from pending_sessions$
> 2.select count(*) from pending_sub_sessions$
>
> Cheers
> JC
> > Thanks in advance,
> > Sunil.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 12 2000 - 00:00:00 CDT