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.