Oracle DBA Lesson 64 Part 2 — Choose an Undo Remedy from the Failing Workload

A long report losing its required history and a transaction unable to allocate undo need different investigations. Use the affected wor...

Read the full lesson

Oracle DBA Lesson 64 Part 1 — Find Which Container Owns the Undo

For permanent-table transactions in Oracle Database 19c, establish the CDB undo mode , the container that owns the undo storage , and t...

Read the full lesson

Oracle DBA Lesson 63 Part 2 — Explain What a Concurrent Reader Sees

Oracle's default READ COMMITTED isolation gives each ordinary query a committed view consistent to the time that statement opens. ...

Read the full lesson

Oracle DBA Lesson 63 Part 1 — Follow One Change into Undo and Redo

A conventional update of a permanent table creates undo information for reversing the change and redo records for recovering database c...

Read the full lesson