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).
