Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: open cursors - x$kgllk - why kgllkhdl <> kglhdpar
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