Oracle
1Z0-064 · Question #6
1Z0-064 Question #6: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #6. The question stem and answer options stay visible for context.
Question
Examine the parameters set for a database instance supporting a mixed workload: The database instance supports shared server and dedicated server connections simultaneously. Users complain about increased response times of a few DSS queries. During investigation, you execute the queries: Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)
Exhibits
Options
- AUse a parallel hint in the queries.
- BIncrease the number of DBWn processes.
- CIncrease the value of the SORT_AREA_SIZE initialization parameter.
- DIncrease the size of the temporary tablespace or add a new temporary tablespace.
- EIncrease the value of the PGA_AGGREGATE_TARGET initialization parameter.
- FIncrease the size of the large pool.
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.