My Oracle Support Banner

Common Questions on Space/Storage Specifics of Compressed Table (Doc ID 1508847.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Oracle Database - Enterprise Edition
Information in this document applies to any platform.


 Scripts/Snippets for Common questions on space/storage specifics of compressed table.

Primary purpose is to provide instrumentation improvements (that is script, tools to diagnose, answers these sort of questions).


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Q1: How to identify fragmentation in compressed table?
 Q2: How to identify how many rows are compressed?
 Q3: How to identify the used blocks and how many rows are in them?
 Q4: How to identify the empty blocks in a compressed table? 
 Q5: How to identify the High Water Mark? 
 Q6: How to identify the amount of free space in blocks in a compressed table?
 Q7: How to identify the chained and migrated rows?
 Q8: How to identify if the table was switched from compress to nocompress?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.