Exam 1z0-064 topic 1 question 37 discussion

Actual exam question from Oracle's 1z0-064

Question #: 37
Topic #: 1

Examine the parameters set for a database instance:

The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:

Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)

A. Enable temporary undo.
B. Enable Automatic Memory Management.
C. Increase the number of DBWn processes.
D. Enable Automatic Shared Memory Management.
E. Increase the value of the SGA_TARGET parameter.
F. Increase the value of the PGA_AGGREGATE_TARGET parameter.

Show Suggested Answer

Suggested Answer: CE 🗳️

by adz07 at Dec. 14, 2023, 7:23 p.m.

Comments

Submit Cancel

adz07

1 year, 3 months ago

I think BF https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/tuning-program-global-area.html#GUID-6D7A1290-77B1-4388-BA84-73B8594DCF44

upvoted 1 times

...