Which two would you recommend as long-term solutions fo…

Examine the parameters set for a database instance:

An application performs a large number of identical queries on small lookup tables very frequently. Users
complain about the slow response time of queries on these tables. On investigation, you notice that buffers are
getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and
SGA_TARGET parameters, but after some time, you notice the same issue again.
Which two would you recommend as long-term solutions for this issue? (Choose two.)

Examine the parameters set for a database instance:

An application performs a large number of identical queries on small lookup tables very frequently. Users
complain about the slow response time of queries on these tables. On investigation, you notice that buffers are
getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and
SGA_TARGET parameters, but after some time, you notice the same issue again.
Which two would you recommend as long-term solutions for this issue? (Choose two.)

A.
increasing the size of the database buffer cache

B.
configuring Automatic Memory Management

C.
configuring the KEEP buffer pool and altering tables to use the KEEP pool

D.
pinning the cursors of the queries in the library cache

E.
configuring the result cache for the instance



Leave a Reply 0

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