Database Administration (MOSC)

MOSC Banner

Decreasing PCTFREE on large table

edited Feb 27, 2021 4:05PM in Database Administration (MOSC) 4 commentsAnswered ✓

Question about Oracle Database Enterprise Edition version 19.10.0.0.0 running as a standalone instance.

I have a table with billions of rows. The table has always had PCTFREE set to 10.

It turns out that we only ever perform inserts on this table, no updates, no deletions. I would like to save disk space by lowering PCTFREE to 0.

As I understand it, if I just do ALTER TABLE x PCTFREE 0 then in my case, only future allocated blocks are affected. But all the millions of existing blocks will never be filled above 90%.

Is there a way to get all the old blocks "re-evaluated" and put back on the freelist after I lower PCTFREE?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center