What would you do?

View the Exhibit that shows your investigation on degraded performance.What would you do?
(Choose all that apply.)

View the Exhibit that shows your investigation on degraded performance.What would you do?
(Choose all that apply.)

A.
Shrink the temporary segment.

B.
Keep the large tables in the KEEP pool.

C.
Use free list groups wherever applicable.

D.
Increase the value set to the PGA_AGGREGATE_TARGET parameter.

E.
Switch the segments to Automatic Segment Space Management (ASSM).



Leave a Reply 1

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


L. Zhu

L. Zhu

ASSM helps to resolve free list / segment header / buffer busy wait issue

C is right
E is right