What could be the problem?

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.

What could be the problem?

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.

What could be the problem?

A.
There are excessive disk sorts.

B.
There are excessive memory sorts.

C.
There is a contention due to free list management.

D.
The tablespace that contains the segments on which waits are occurring is full.

E.
The server process is processing buffers at a rate that is faster than the rate at which the I/O
system can return the buffers.



Leave a Reply 1

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


L. Zhu

L. Zhu

this is free list management contention

C is right