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 theSGA_MAX_SIZEandSGA_TARGETparameters, 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 theSGA_MAX_SIZEandSGA_TARGETparameters, 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 theKEEPbuffer pool and altering tables to use theKEEPpool

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

E.
configuring the result cache for the instance



Leave a Reply 6

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


vasya

vasya

imo C and E right

job

job

really, b? if they are aged out of the BC what makes you think itll improve anything? sga has been increased already. so c for the small tables and result cache for the identical queries