Oracle Exam 1Z0-064 Topic 9 Question 24 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 24
Topic #: 9

Examine the parameters:

Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and a high number of direct path write wait events.

Which two actions could improve the performance? (Choose two.)

Aincreasing the value of the SORT_AREA_SIZE parameter

Bincreasing the value of the PGA_AGGREGATE_TARGET parameter

Cenabling Automatic Memory Management for the instance

Dincreasing the size of the default temporary tablespace

Eusing parallel hint in queries performing large sort operations

Fenabling Automatic Shared Memory Management for the instance

Show Suggested Answer

Suggested Answer: A, F

by Diane at May 05, 2022, 10:33 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!