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

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.