View the Exhibit that shows your investigation of performance degradation in your database. You also know that there are a few tablespaces using automatic segment-space management in the database…

Question

Exhibit

Options

• AThere are excessive disk sorts.
• BThere are excessive memory sorts.
• CThere is a contention due to free list management.
• DThe tablespace that contains the segments on which waits are occurring is full.
• EThe server process is processing buffers at a rate that is faster than the rate at which the I/O

• A
  8% (5)
• B
  2% (1)
• C
  84% (52)
• D
  2% (1)
• E
  5% (3)

No community discussion yet for this question.