Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: library cache load lock

Re: library cache load lock

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 13 Jun 2007 14:03:05 -0500
Message-ID: <4670332a$0$16379$88260bb3@free.teranews.com>


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.com
Received on Wed Jun 13 2007 - 14:03:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US