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,