Biju

www.bijoos.com

Oracle Tidbits – May & June 2015

by

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in May and June 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Date TidBit 11-May … Read more

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