RE: library cache pin wait

This sounds like a problem related to 'recompiling'. How have you built the packages? (i.e. have you used TOAD in debug mode?) have you checked for invalid objects? Have you run utlrp after recompiling the package?

hth

Guillermo Alan Bort
EDS - ITO DBA Main Group

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA Sent: Tuesday, October 07, 2008 9:48 AM
To: oracle-l_at_freelists.org
Subject: Re: library cache pin wait

No java. All the procedures are similiar. They are rolling up to summary tables in a data warehouse.

So they do the following

1. grab a sequence value
2. set dbms_application_info
3. insert to a log table saying "I am running". procedure that does the insert is an autonomous transaction
4. run an insert select if there is no data in the summary, run a merge if there is data in the summary.
5. call the log procedure again to update the log when done

That is it. I have similiar code in other packages. This only seems to happen now, right after I recompile the code to make changes. It only happens in our production RAC environment (I do not have a dev or test RAC environment).

once it completes once, I don't get library cache waits anymore. The other package that is very similiar, does not have this problem.

--
http://www.freelists.org/webpage/oracle-l