You query the V$SHARED_POOL_RESERVED dynamic performance view and notice that REQUEST_FAILURES is greater than zero and increasing. What should you do?
A. Reserved pool is too small; increase the SHARED_POOL_RESERVED_SIZE init.ora parameter.
B . No action is required as long as REQUEST_MISSES is not increasing.
C . Reserved pool is too small; increase the SHARED_POOL_RESERVED_SPACE init.ora parameter.
D . REQUEST_FAILURES will always be zero if the shared pool reserved space is configured.
Explanation:
Answer A: The REQUEST_FAILURES column indicates the number of times the reserved list did not have a free piece of memory to satisfy the request, and started flushing objects from the LRU list. To remedy this, increase the size of the shared pool reserved space by increasing the SHARED_POOL_RESERVED_SIZE parameter.
No comments:
Post a Comment