When I execute:
SELECT (1 - (Sum(misses) / Sum(gets))) * 100
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.