Hi, A small example: I executed a SQL statement "select /* tanel */ count(*) from t" over two times, thus the statement remained cached, meaning that a library lock state object is added to my processes state object tree in SGA. If you dump state objects for your process using the processstate for example, then you get a bunch of flags under library object handle for locked library cache objects: SO: 2F764790, type: 51, owner: 2EA3C5AC, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=2f764790 handle=2fdea87c mode=N call pin=2F7657E0 session pin=00000000 htl=2F7647CC[2F776A08,2F776A08] htb=2F776A08 user=2ea3c5ac session=2ea3c5ac count=1 flags=[00] savepoint=1258 LIBRARY OBJECT HANDLE: handle=2fdea87c name=select /* tanel */ count(*) from t hash=796ec347 timestamp=04-13-2004 17:24:19 namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000] See the last row above, it has flags=RON/KGHP/TIM/PN0/SML/ and the bitvector [12010000] seen also in x$kglob.kglhdflg. So in principle, it's possible to dump a bunch of library cache locks and get the information out from lock handles, which flag does match which bit it the bitmap. And then it's up to imagination to find out which flag does mean what ;) RON for example means that this library object isn't stored within the parent structure (processes state object) itself, but is somewhere else - in my example it's a shared cursor, PN0 means that this library object's heap 0 is kept pinned as long as the library object itself is locked, in order to avoid aging out the heap 0. The standard comments apply, this is gray area to me as well, don't necessarily believe what I say ;) Tanel. ----- Original Message ----- From: "Sultan Syed" <ssyed@xxxxxxx> To: "oracle freelists.org" <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, April 13, 2004 4:28 PM Subject: decode of flag on x$kglob > Hi list, > Could somebody give some scripts or comments > on the decode of KGLHDFLG on x$kglob,please. > Thanks in advance > Syed > > > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------