Re: Shared pool latches

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Thu, 2 Dec 2004 15:22:39 +0100
Message-ID: <3b0f44a10412020622255b2b69@mail.gmail.com>

Manmohan:

The number of shared pool latches are automatically configured by oracle based on the shared pool size and the number of CPUs. If your shared pool is bigger then 250M and if you have atleast 4 CPUs then the mutilple shared pool latches comes in to picture.

You can change this behavior by setting _kghdsidx_count parameter. There is a detailed discussion about multiple shared (sub) pool in OWI book. Have a look if you have this book handy.

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 02 2004 - 08:20:18 CST