What could be a few tablespaces using automatic segment-space management in the database?

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?
Exhibit:

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 0

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