1Z0-054 · Question #65
You are working for a company that uses huge applications to manage its customer details. During your regular performance checks, you executed the following query: SQL> show parameter…
The correct answer is B. The reserved pool is large and has free space to satisfy requests. See the full explanation below for the reasoning.
Question
You are working for a company that uses huge applications to manage its customer details. During your regular performance checks, you executed the following query:
SQL> show parameter shared_pool_reserved_size NAME TYPE VALUE ------------------------------ --------------------- ----------------- shared_pool_reserved_size big integer 6920601 SQL> SELECT free_space, used_space, request_misses, request_failures from V$SHARED_POOL_RESERVED; FREE_SPACE USED_SPACE REQUEST_MISSES REQUEST_FAILURES ---------- ---------- -------------- ---------------- 6469776 555528 0 113 You observed that REQUEST_FAILURES is 113 but not increasing, and also that REQUEST_MISSES is not increasing. What would you interpret from this?
Options
- AThe reserved pool is very large.
- BThe reserved pool is large and has free space to satisfy requests.
- CThe reserved pool is very small and is not finding enough memory to satisfy requests.
- DThe reserved pool is very small and is not finding enough memory to satisfy requests.
How the community answered
(14 responses)- A7% (1)
- B71% (10)
- C7% (1)
- D14% (2)
Community Discussion
No community discussion yet for this question.