Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
boostr.in questions - Question:A database is used by an OLTP application. What is the recommended Library Cache GETHITRATIO percentage that should be achieved? How can the GETHITRATIO percentage be increased in the V$LIBRARYCACHE?
a. Â Â Â Â Â Â Â 90% - 100%;improve the efficiency of the application code
b. Â Â Â Â Â Â Â 80% - 85%; analyze the tables
c. Â Â Â Â Â Â Â 85% - 90%; improve performance by increasing the SHARED_POOL_SIZE
d. Â Â Â Â Â Â Â 90% - 95%; improve performance by increasing the LARGE_POOL_SIZE
Sep 13, 2013
Sep 12, 2013
to add a comment.
Related Hot Questions
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please