Performance Tuning - Question 107

Which component will NEVER allocate memory from the large pool?

A. Oracle Library Cache.

B. Oracle Parallel Query.

C. Oracle Recovery Manager.

D. Oracle Multithreaded Server.

Answer: A

Explanation:

Oracle Library Cache will NEVER allocate memory from the Large Pool.

Incorrect Answers

B: Oracle Parallel Query (PQ) can cause the Shared Pool to cache additional items not related to application SQL. That’s why it can allocate memory from the Large Pool.

C: Oracle Recovery Manager (RMAN) utility can use the Large Pool to process requests for optional features.

D: UGA information for the Shared Sever option is cached in the Large Pool if it’s defined. Otherwise, it uses the Shared Pool.

OCP: Oracle 9i Performance Tuning Study Guide, Jaseph C. Johnson, p. 308-310

Chapter 8: Tuning Other SGA Areas