溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
Examine the parameters for a database instance:
NAME TYPE VALUE
temp_undo_enabled boolean TRUE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBSl
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 wait until space becomes available in undotbs1.
C. Transactions write their undo in a temporary tablespace.
D. Transactions fail.
Answer: D
【解析】
UNDO表空間中，活動事務使用的空間是不能夠被覆寫的。如果UNDO表空間空間滿，無法覆寫時，新的事務無法分配UNDO空間，因此會失敗。
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
