Expertos,

a user of mine is hanging waiting for a library cache pin. I found the
following query on the web:

SQL> SELECT kglnaown AS owner, kglnaobj as Object
2 FROM sys.x$kglob
3 WHERE kglhdadr='&P1RAW'
4 /


I have got the P1RAW from v_session_wait but when I try and get the
kglnaown I get an error that sys does not exist..........

Can any one please advise?

Thanks




-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com

Oracle LazyDBA home page