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

Oracle DBA Lesson 62 Part 2 — Resolve a Suspended Space Request

Resumable space allocation gives certain operations time to recover from a supported allocation error. Oracle suspends the statement, r...

Read the full lesson

Oracle DBA Lesson 62 Part 1 — Reclaim Space from a Sparse Table

Segment shrink reorganizes an eligible segment in place so fragmented free space can become reusable tablespace capacity. Choose it aft...

Read the full lesson