Re: X$_kglcursor.kglnaobj

Ian
        These rows relate to the library cache pin on the metadata about the objects. Metadata for the objects need to be pinned during the execution of the statement to prevent the invalidation of the dependent objects. Since each one of this sid has this object pinned, I think, you have objects with these names in your database. Does your database have these objects ?

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com

"MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> Sent by: root_at_fatcity.com
08/10/01 06:45 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:        
        Subject:        X$_kglcursor.kglnaobj

I use the following statment when monitoring the database

select   sid, s.username,s.osuser,   c.kglnaobj from   sys.x$_kglpn  p,   sys.x$_kglcursor  c,   v$_session  s where   p.kglpnhdl = c.kglhdadr and   p.kglpnses = s.saddr;

Here is some output showing sid and kglnaobj:

      28

table_1_0_116_0_0_

      80

SELECT LOC,RACK,SLOT,ELE,CONNNUM,PIN,RLOC,RRACK,RELE,RSLOT,RCONNNUM,RPIN FROM CAPTAR.LINKTERM WHERE (LOC=:1) and (RACK=:2) and (CONNNUM=:3) and (PIN LIKE '%L') order by loc, rack, ele, slot, connnum, orderpin, pin

      28

table_1_0_112_0_0_

      28

table_1_0_11a_0_0_

      82

table_1_0_112_0_0_

      28

table_1_0_11a_0_0_

      82

table_1_0_112_0_0_

What is the meaning of  the lines which start with "table_"?

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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