Oracle

1Z0-054 · Question #105

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

The correct answer is C. Use free list groups wherever applicable. E. Switch the segments to Automatic Segment Space Management (ASSM). See the full explanation below for the reasoning.

Question

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

Options

AShrink the temporary segment.
BKeep the large tables in the KEEP pool.
CUse free list groups wherever applicable.
DIncrease the value set to the PGA_AGGREGATE_TARGET parameter.
ESwitch the segments to Automatic Segment Space Management (ASSM).

How the community answered

(50 responses)

A
8% (4)
B
4% (2)
C
72% (36)
D
16% (8)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-054 Practice