What would you interpret from this?

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?

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?

A.
The reserved pool is very large. Consider reducing the size of the shared pool.

B.
The reserved pool is large and has free space to satisfy requests. Consider reducing the size of the reserved pool.

C.
The reserved pool is very small and is not finding enough memory to satisfy requests.
Increase the size of the shared pool.

D.
The reserved pool is very small and is not finding enough memory to satisfy requests.
Increase the size of the reserved pool.



Leave a Reply 0

Your email address will not be published. Required fields are marked *