On Wed, 01 Dec 2004 19:01:55 -0500, Manmohan Jalsingh <mjalsing@xxxxxxxxx> wrote: > Hi, > > Is there any reason why Oracle is not using all the shared pool latches. > In one of our database, we have 7 shared pool latches, but only 3 are being > used. Gets/Imme gets for other shared pool latches are 0. > > Thanks. > Manmohan what is the size of the shared_pool? how many CPUs (both physical and logical) exist in the server (domain)? Is this the same operating system and database software version as the other post, which was Oracle 10g / RHEL 3.0 Update 2 / Lintel x86-64? perhaps you have perfectly written SQL and there is no parsing taking place whatsoever. :) Paul -- //www.freelists.org/webpage/oracle-l