From ian@SLAC.Stanford.EDU Mon, 13 Aug 2001 11:10:28 -0700
From: "MacGregor, Ian A." <ian@SLAC.Stanford.EDU>
Date: Mon, 13 Aug 2001 11:10:28 -0700
Subject: RE: X$_kglcursor.kglnaobj
Message-ID: <F001.00369060.20010813111127@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@slac.stanfprd.edu">ian@slac.stanford.edu

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Riyaj_Shamsudeen@i2.com 
  [mailto:Riyaj_Shamsudeen@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@SLAC.Stanford.EDU> <FONT face=sans-serif 
        size=1>Sent by: root@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@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@slac.stanford.edu-- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com-- Author: MacGregor, Ian A. INET: 
  ian@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@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).