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

Oracle DBA Lesson 61 Part 2 — Evaluate Compression on a Representative Copy

A useful compression result preserves the data, saves meaningful space, and meets the loading and response-time requirements of the rea...

Read the full lesson

Oracle DBA Lesson 61 Part 1 — Match Compression to the Way Data Changes

Choose a table-compression candidate from the way its data is loaded and changed, then confirm that the database edition, service, lice...

Read the full lesson