Oracle Memory Management Question:

What is hit ratio?

Memory Management Interview Question
Memory Management Interview Question

Answer:

Hit Ratio is the ratio of shared SQL and PL/SQL items found in the Library Cache versus physical storage.It can also be defined in a mathematical expression as 1 - ((physical reads) / (db block gets + consistent reads)).


Previous QuestionNext Question
What is a rollback segment entry?What are disadvantages of having raw devices?