Oracle Exam 1Z0-064 Topic 4 Question 14 Discussion

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

Question #: 14
Topic #: 4

You are administrating a database that supports a mixed workload. Given are the details of the workload:

During the day, short transactions and syntactically similar queries are repeatedly issued.

At night, DSS batch queries and jobs are executed with large sort operations.

Examine the parameters set for the database instance:

To automate memory requirements for both workloads, which three changes to parameters would you recommend?

ASet the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to a value greater than the sum of SGA_MAX_SIZE and PGA_AGGREGATE_TARGET.

BSet the SGA_TARGET and PGA_AGGREGATE_TARGET parameters to their minimum required values.

CSet DB_CACHE_SIZE, SHARED_POOL_SIZE, and LARGE_POOL_SIZE to their minimum required values.

DSet the SGA_TARGET parameter to the value of the SGA_MAX_SIZE parameter.

ESet the MEMORY_TARGET parameter to the value of SGA_MAX_SIZE.

Show Suggested Answer

Suggested Answer: B, C, D

by Joni at May 08, 2022, 09:12 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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