Examine the parameters set for a database instance supporting a mixed workload:The database instance supports shared ser
Posted: Sun Jun 11, 2023 3:54 pm
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.
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.
- Examine The Par 1 (34.31 KiB) Viewed 276 times
- Examine The Par 2 (67.45 KiB) Viewed 276 times
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.