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 DBWnprocesses.
C.
Increase the value of theSORT_AREA_SIZEinitialization parameter.
D.
Increase the size of the temporary tablespace or add a new temporary tablespace.
E.
Increase the value of thePGA_AGGREGATE_TARGETinitialization parameter.
F.
Increase the size of the large pool.
I’d go for E and F.
E because we have few multipass workarea executions which means lack of PGA.
F because of shared servers.
E,F
F must be indirectly eliminated as users who complain run DSS queries, those users must use dedicated connections so why to care about large pool for shared servers!
Due to the lack of missing information or insufficient information, I would go with C & E!
EF
RobSala why wold DSS use only dedicated connection ??
E,F