Oracle Database

Oracle Database, the related services (cloud) and various options in the database.

Oracle #DB12c New – TEMP_UNDO_ENABLED

by

Global temporary table data is stored in the temporary tablespace (where no redo will be generated on the DML operations). When DML operations are performed on global temporary table, for read consistency undo must be generated. Such undo records are written to undo tablespace, and thus redo generated on the undo writes. If you perform … Read more