What would you do to avoid transactional failures?

You are checking every 10 minutes for alerts regarding the violation of tablespace usage threshold. Some of the tablespaces’ fullness was not detected on time. As a result the transactions were aborted before you had a chance to resolve the space issue. What would you do to avoid transactional failures?

You are checking every 10 minutes for alerts regarding the violation of tablespace usage threshold. Some of the tablespaces’ fullness was not detected on time. As a result the transactions were aborted before you had a chance to resolve the space issue. What would you do to avoid transactional failures?

A.
Use bigfile tablespaces (BFTs)

B.
Enable resumable space allocation

C.
Modify the background process PMON settings

D.
Modify the LOG_CHECKPOINT_TIMEOUT parameter

E.
Reduce the default tablespace usage threshold values for the database.



Leave a Reply 1

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


mr_tienvu

mr_tienvu

I have the same idea. A