1Z0-064 · Question #58
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…
The correct answer is A. increasing the size of the database buffer cache B. configuring Automatic Memory Management. See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- Aincreasing the size of the database buffer cache
- Bconfiguring Automatic Memory Management
- Cconfiguring the KEEP buffer pool and altering tables to use the KEEP pool
- Dpinning the cursors of the queries in the library cache
- Econfiguring the result cache for the instance
How the community answered
(43 responses)- A74% (32)
- C14% (6)
- D5% (2)
- E7% (3)
Community Discussion
No community discussion yet for this question.