which two courses of action would you recommend to impr…

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.)

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.)

A.
Use a parallel hint in the queries.

B.
Increase the number of DBWn processes.

C.
Increase the value of the SORT_AREA_SIZE initialization parameter.

D.
Increase the size of the temporary tablespace or add a new temporary tablespace.

E.
Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

F.
Increase the size of the large pool.



Leave a Reply 0

Your email address will not be published. Required fields are marked *