|
Explanation: The V$SHARED_POOL_RESERVED dynamic performance view is designed to assist in tuning shared-pool reserved-list configuration. An important column is REQUEST_FAILURES, indicating the number of shared pool space requests that weren't granted. If value for this column is always increasing, you should increase SHARED_POOL_SIZE and SHARED_POOL_RESERVED_SIZE. Incorrect Answers:
1: The LARGE_POOL_SIZE parameter is not related with V$SHARED_POOL_RESERVED view. 2: The LARGE_POOL_SIZE parameter is not related with V$SHARED_POOL_RESERVED view. 4: You should increase, not decrease the SHARED_POOL_SIZE parameter. 6: You should increase, not decrease the SHARED_POOL_RESERVED_SIZE parameter. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 857-858. Chapter 18: Tuning Memory and Operating System Use
|