-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|