shrink | The ORACLE-BASE Blog

Video : SecureFiles Shrink in Oracle Database 21c

In today’s video we’ll demonstrate the SecureFiles Shrink feature, introduced in Oracle database 21c.

The video is based on this article.

Space Management Enhancements in Oracle Database 21c

You might also find these useful.

Online Segment Shrink for Tables : Free Unused Space (video)
ALTER TABLE … SHRINK SPACE Command : Online Segment Shrink for Tables, LOBs and IOTs
Reclaiming Unused Space in Datafiles

The star of today’s video is Arman Sharma. This clip was from Sangam15. To think that was seven years ago is mind-blowing!

Cheers

Tim…

Video : Online Segment Shrink for Tables : Free Unused Space

In today’s video we’ll give a demonstration of how to shrink tables that contain a lot of free space. As I say in the video, this is not something you should do regularly. It’s only necessary if you’ve done some drastic one-off maintenance, like a large data purge maybe.

There are a few articles this relates to.

ALTER TABLE … SHRINK SPACE Command : Online Segment Shrink for Tables, LOBs and IOTs
Online Statistics Gathering for Bulk Loads in Oracle Database 12c Release 1 (12.1)
Reclaiming Unused Space in Datafiles

The star of today’s video is Kellyn Pot’Vin-Gorman, who is returning to her Oracle roots, but on Azure. 🙂

Cheers

Tim…