Hi,
I read it on a openworld paper "Understainding Shared Pool Memory
Structures"
There the authors explain the mutexes are to improve cursor execution and
also hadr parsing, I was only giving a clue where you can continue
investigating, I'm not suggesting to change the hidden parameter to fix
anything, that are Alex inner voices :).
On 11/22/06, Anand Rao <panandrao_at_gmail.com> wrote:
>
> Ok, got around to checking the value on my instance and as expected it is
> false.
>
> but why would i want to enable Mutexes to get rid of SQLs being pinned in
> shared pool?
>
> can you please throw some light on your suggestion to use mutexes?
>
> thanks
> anand
>
> On 21/11/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
>
> >
> > Hi,
> > Maybe this could help you
> > Mutexes, new on 10gr2
> > You enable it with this parameter
> > _kks_use_mutex_pin,
> >
> >
> >
>
--
----------------------------------------
http://www.oracleboliviaspecialists.com/
Oracle Certified Profesional 9i 10g
Oracle Certified Professional Developer 6i
10 years of experience from Oracle 7 to Oracle10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 22 2006 - 07:00:57 CST
