Prev Question
Next Question

Examine the parameters for a database instance:

5a4b979a84429 - What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active
transactions?

A.
Transactions write their undo in the SYSTEM undo segment.

B.
Transactions fail.

C.
Transactions wait until space becomes available in UNDOTBS1.

D.
Transactions write their undo in a temporary tablespace.

Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

Prev Question
Next Question

Leave a Reply

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