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?
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!