RE: open cursors - x$kgllk - why kgllkhdl <> kglhdpar

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Thu, 17 Aug 2000 16:21:10 +1000
Message-Id: <10591.114800@fatcity.com>

Hi Rahul,

For every cursor there is both a parent and a child handle. If there are multiple versions, then there are multiple children. An "open cursor" retains a lock on both the parent and child, but users of the view would be confused if they saw both.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Thursday, 17 August 2000 16:08
To: 'Oracle List I'; 'Oracle List II'
Subject: open cursors - x$kgllk - why kgllkhdl <> kglhdpar

List,
x$kgllk lists currently issued sql's by a session, when selecting from this structure, all statements are displayed twice ! why ?

v$open_cursor is based on x$kgllk, it selects where kgllkhdl IS NOT EQUAL to
kglhdpar.

where do these two columns point to ? and why they must not be equal to return the
open cursors ?

TIA
Rahul

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Thu Aug 17 2000 - 01:21:10 CDT