You are administering a database that supports a DSS workload. Automatic SharedMemory Management is enabled for the data

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You are administering a database that supports a DSS workload. Automatic SharedMemory Management is enabled for the data

Post by answerhappygod »

You are administering a database that supports a DSS workload. Automatic SharedMemory Management is enabled for the database instance. Users issue queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing multipass work area executions and the I/O contention on one of the temporary tablespaces is very high.Which two can be possible resolutions for this issue? (Choose two.)

A. Increase the size of the large pool.
B. Increase the value of the PGA_AGGREGATE_TARGET parameter.
C. Create a temporary tablespace group and assign it to users.
D. Increase the value of the PGA_AGGREGATE_LIMIT parameter. E. Create another temporary tablespace and assign it to users. F. Enable temporary undo.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply