Re: how to find total open database links in a database?

From: <jkstill_at_gmail.com>
Date: 18 Oct 2005 23:36:34 -0700
Message-ID: <1129703794.624231.291210@o13g2000cwo.googlegroups.com>

niy38_at_hotmail.com wrote:
> and open_links and open_links_per_instance seems doesn't work
> for my instance. The value is 4, but I can have open links more
> than 4, for each session or a instance.

This may be useful, courtesy of Mark Bobak.

• Jared

Select /*+ ORDERED */

substr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10)      "ORIGIN",
substr(g.K2GTITID_ORA,1,35) "GTXID",
substr(s.indx,1,4)||'.'|| substr(s.ksuseser,1,5) "LSESSION" ,

s2.username,
substr(

        decode(bitand(ksuseidl,11),
                1,'ACTIVE',
                0, decode( bitand(ksuseflg,4096) ,
0,'INACTIVE','CACHED'),
                2,'SNIPED',
                3,'SNIPED',
                'KILLED'
        ),1,1

) "S",
substr(event,1,10) "WAITING"
from x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w, v$session s2 where g.K2GTDXCB =t.ktcxbxba
and g.K2GTDSES=t.ktcxbses

and  s.addr=g.K2GTDSES
and  w.sid=s.indx
and s2.sid = w.sid

Received on Wed Oct 19 2005 - 01:36:34 CDT