TEMP_UNDO_ENABLED
ð
TEMP_UNDO_ENABLED
helps to reduce the amount of redo caused by DML on global temporary tables.
ð
Setting to TRUE may cause serious issues, such as ORA-55526, for distributed transactions (Ref. Bug 20712819).
ð
The recommended value for systems using
distributed transactions is currently FALSE
(Pending ER 24286334).
ð
If not using distributed transactions, TRUE will improve performance by
eliminating REDO on permanent UNDO.
temp_undo_enabled = FALSE
No comments:
Post a Comment