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-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Thursday, August 17, 2000 12:55 PM To: Multiple recipients of list ORACLE-L 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

-- 
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).