Re: Oracle 10g: SQL Statements KEPT in the Shared Pool

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@xxxxxxxxx> 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@xxxxxxxxx> 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

Other related posts: