RE: library cache pin wait
Date: Tue, 7 Oct 2008 08:01:29 -0500
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?
Guillermo Alan Bort
EDS - ITO DBA Main Group
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA Sent: Tuesday, October 07, 2008 9:48 AM
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
- grab a sequence value
- set dbms_application_info
- insert to a log table saying "I am running". procedure that does the insert is an autonomous transaction
- run an insert select if there is no data in the summary, run a merge if there is data in the summary.
- 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.Received on Tue Oct 07 2008 - 08:01:29 CDT