Where can I read database compression properties after the creation of an oracle database / tables? Is there a special view where the info is stored and can be retieved?
Oracle SecureFile Compression
compressionmetadataoracle
Related Question
- Oracle Database – Remove Windows NTFS Compression from Datafiles
- Sql-server – SQL Server Compression Estimate Is Significantly Lower When Estimating Current Compression Type
- External compression tools for database backup files
- Compression Setting Ineffective for Differential Backup Maintenance Plan
- Oracle MOVE COMPRESS – Impact on Future Data
Best Answer
Assuming you have the appropriate DBA-level permissions, you can try this to get some basic information on the SecureFile/LOBs in your system:
You can get the size on disk for a specific table name (your table with a SecureFile/LOB) by doing this:
To get the actual compression rating (no/low/high), try this using your table name:
Hope this helps!