| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: strange library cache lock/ping wait event
Hi, yong:
This is the database of my friend, and it is in beijing.
I have found some suspected question and asked them to modify the
application to see if this works. They used row level security. I traced the
session with most library cache lock/pin wait event and found two procedure
have caused most of the wait. I look into the source code and the common
point is that there is enable/disable policy in the procedure.With some
simple test, enable/disable policy can cause sql invalidation. This will
cause sql reparse.
I have asked my friend to modify their application and see if there is still hang. I will let you know if there is new message from him.
Thanks.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
----- Original Message -----
To: "zhu chao" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 2:02 AM
> According to Steve Adams' book pp.50-51, library cache locks and pins are
also
> held when SQL or PL/SQL is being parsed and executed.
>
> P.51 also has the p1,2,3 parameter explanation for the wait.
>
> Yong
>
> --- zhu chao <[EMAIL PROTECTED]> wrote:
> > question 1: Can we use tracefile of 10046 to diag the library cache
> > lock/pin wait event according to the p1,p1raw, p2 etc?
> > Question 2: Besides ddl/compile, what can cause library cache
contention
> > according to your experience? Can row level security cause high library
> > cache contention?
>
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).Received on Wed Jul 09 2003 - 21:36:45 CDT
 |
 |