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

Babu / List,

x$kgllk = ALL cursors which are currently OPEN, first 60 bytes of the cursor

KSUSESQL(x$ksuse) / $kglna = the FULL text of the latest sql executed by this session.

a session can have multiple cursors open (x$kgllk), but only one "latest" statememt (x$kglna)

list, please confirm...
TIA
Rahul

> ----------
> From:
> babu.nagarajan_at_mail.iflexsolutions.com[SMTP:babu.nagarajan_at_mail.iflexsolut
> ions.com ]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, August 17, 2000 8:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: open cursors - x$kgllk - why kgllkhdl <> kglhdpar
>
> hi
>
> x$ksuse and x$kglna together will give you the latest sql for a session.
> x$kgllk will give you the latest opened cursor..
> am i right here?
>
> next, will x$kgllk have an entry for both implicit and explicit cursors -
> a
> select from the view tells me yes, but i just want to confirm..
>
> and what are the statements that will come under x$kgllk and what will
> not..
> some of the latest sqls that are selects do not appear in the x$kgllk
> while
> some do. i am not able to see then in sync reg the sql .. why ? is it cos
> they rapidly change or is it 'cos of something else
>
> Babu Nagarajan
> i-Flex, Bangalore
> #91-80-5597600-3381
>
>
>
>
> -----Original Message-----
> Sent: Thursday, August 17, 2000 12:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
>
>
>
>
>
>
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author:
> INET: babu.nagarajan_at_mail.iflexsolutions.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Aug 17 2000 - 22:28:15 CDT