Organizational Research By

Surprising Reserch Topic

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

Related Hot Questions

Government Jobs Opening