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

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

Hi Rahul,

1. Yes, 2 locks. One on the child, and one on the parent.
2. Yes.
3. No, the address of the call pin.
4. The address of the session pin.

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:38
To: 'Oracle List I'; 'Oracle List II'
Subject: RE: open cursors - x$kgllk - why kgllkhdl <> kglhdpar

> Steve/List,
>
> 1) meaning, one child is always present ? because i just issued a new
> distinct sql
> and kgllk still shows two.
>
> 2) kglhdpar = kgllkhdl, parent sql ?
>
> 3) KGLLKPNC = pin count ?
>
> 4) KGLLKPNS = ?
>
> Regards,
> Rahul
>
>
> ----------
> From: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Sent: Thursday, August 17, 2000 1:21 PM
> To: Rahul; 'Oracle List I'; 'Oracle List II'
> Subject: 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
>
>
>
>
>
>
>
> --------
> 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
>
>

---

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 Received on Thu Aug 17 2000 - 02:16:29 CDT