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." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 08/10/01 06:45 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
