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 --=20 _______________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as= p?SRC=3Dlycos10 -- //www.freelists.org/webpage/oracle-l