Multiple choice

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?

  1. 90% - 100%; improve the efficiency of the application code.

  2. 80% - 85%; analyze the tables.

  3. 85% - 90%; improve performance by increasing the SHARED_POOL_SIZE.

  4. 90% - 95%; improve performance by increasing the LARGE_POOL_SIZE.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

For an OLTP application, the Library Cache GETHITRATIO should be 90-100%. This ratio measures how often parsed SQL statements are found in cache without reparsing. Low ratios indicate inefficient application code that doesn't use bind variables or shares SQL properly. The solution is to improve application code, not increase SHARED_POOL_SIZE (which only masks the problem) or LARGE_POOL_SIZE (unrelated to library cache). Option C's 85-90% target is too low for OLTP, and Option D's solution is incorrect.

Keep practicing — related questions