This preview shows page 1. Sign up to view the full content.
Unformatted text preview: RVED is more than zero and always increasing. Which two
actions would be appropriate? (Choose two)
A. Decrease the value for LARGE_POOL_SIZE parameter.
B. Increase the value for LARGE_POOL_SIZE parameter.
C. Increase the value for SHARED_POOL_SIZE parameter.
D. Decrease the value for SHARED_POOL_SIZE parameter.
E. Increase the value for SHARED_POOL_RESERVED_SIZE parameter.
F. Decrease the value for SHARED_POOL_RESERVED_SIZE parameter.
Answer: C, E
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
Actualtests.com - The Power of Knowing 1Z0-024
A: The LARGE_POOL_SIZE parameter is not related with V$SHARED_POOL_RESERVED
B: The LARGE_POOL_SIZE parameter is not related with V$SHARED_POOL_RESERVED
D: You should increase, not decrease the SHARED_POOL_SIZE parameter.
F: 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
Why can you NEVER achieve a value of zero in the GETMISSES column of
A. The database buffer cache can never be empty.
B. Recursive SQL has to be reparsed each time
it is used.
C. Object definitions must be loaded into the shared pool following instance startup.
D. An object cannot be pinned in the shared pool with the DBMS_SHARED_POOL package
until it has been at least once.
It's NEVER possible to achieve a zero value in the GETMISSES column of V$ROWCACHE
view because at least some object definitions must be loaded from the data dictionary into the
shared pool immediately after instance startup.
A: The database buffer cache i...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09