RE: X$_kglcursor.kglnaobj

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Mon, 13 Aug 2001 11:10:28 -0700
Message-ID: <F001.00369060.20010813111127@fatcity.com>

No,
there are no objects with names which start with "table_"  in the database.
<FONT face=Arial color=#0000ff

size=2> 
Ian
MacGregor
<FONT face=Arial color=#0000ff

size=2>Stanford Linear Accelerator Center
<A

href="mailto:ian_at_slac.stanfprd.edu">ian_at_slac.stanford.edu

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Riyaj_Shamsudeen_at_i2.com   [mailto:Riyaj_Shamsudeen_at_i2.com]Sent: Monday, August 13, 2001 9:21   AMTo: Multiple recipients of list ORACLE-LSubject: Re:   X$_kglcursor.kglnaobj<FONT face=sans-serif   size=2>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 ? <FONT   face=sans-serif size=2>ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle   DBAi2 technologies   www.i2.com             

      
      "MacGregor, Ian A." 
        <ian_at_SLAC.Stanford.EDU> <FONT face=sans-serif 
        size=1>Sent by: root_at_fatcity.com 
        08/10/01 06:45 PM <FONT 
        face=sans-serif size=1>Please respond to ORACLE-L 
              <FONT 
        face=sans-serif size=1>        To:     
           Multiple recipients of list ORACLE-L 
        <ORACLE-L_at_fatcity.com> <FONT face=sans-serif 
        size=1>        cc:       
                
          Subject:       

     X$_kglcursor.kglnaobj<FONT
  face="Courier New" size=2>I use the following statment when monitoring the   databaseselect   sid, s.username,s.osuser,   c.kglnaobj from     sys.x$_kglpn  p,   sys.x$_kglcursor  c,     v$_session  swhere   p.kglpnhdl = c.kglhdadr and     p.kglpnses = s.saddr;Here is some output showing sid and   kglnaobj:      28table_1_0_116_0_0_ 
      80SELECT
  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 

      28table_1_0_112_0_0_      
  28table_1_0_11a_0_0_      
  82table_1_0_112_0_0_      
  28table_1_0_11a_0_0_      
  82table_1_0_112_0_0_What is the meaning of  the lines 

  which start with "table_"?Ian MacGregorStanford Linear Accelerator   Centerian_at_slac.stanford.edu-- Please see the official ORACLE-L   FAQ: http://www.orafaq.com-- Author: MacGregor, Ian A. INET:   ian_at_SLAC.Stanford.EDUFat City Network Services    -- (858)   538-5051  FAX: (858) 538-5051San Diego, California          -- Public Internet access / Mailing

  Lists--------------------------------------------------------------------To 

  REMOVE yourself from this mailing list, send an E-Mail messageto:   ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message   BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing   list you want to be removed from).  You mayalso send the HELP command   for other information (like
subscribing). Received on Mon Aug 13 2001 - 13:10:28 CDT