Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: library cache load lock
jernigam_at_nospam.kochind.com wrote:
> I have seen an increase in this wait since we loaded an application
> upgrade. I am trying to look into what changed that would have
> caused it.
>
> This 9.2.0.7 running on Solaris.
> Our cursor_sharing_for_time=false
> I don't see any objects being modified - nothing with a new last_ddl
> date.
> We aren't changing permissions on objects frequently.
> We aren't recompiling any packages.
>
> Any ideas of where to look?
>
You may need to increase your SHARED_POOL_SIZE. Query V$SGASTAT to see if you have enough free memory in the Shared Pool
Otherwise, I suggest you work this issue with the application vendor.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.comReceived on Wed Jun 13 2007 - 14:03:05 CDT