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
