Re: Shared pool latches


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

Other related posts: