Oracle
1Z0-064 · Question #58
1Z0-064 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
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
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.