Dear friends,

When I execute:

SELECT (1 - (Sum(misses) / Sum(gets))) * 100
INTO v_value
FROM v$latch;
DBMS_Output.Put('Latch Hit Ratio : ' || Format(v_value));


I am getting a very low value (less than 70%). I don't see any parameter in the INIT.ORA file to increase the number of latches.


Kindly advise me how to increase the latch hit ratio. Your help will be appreciated.