Search code examples
sqloraclecompression

Check if Advanced Compression is available

I'm searching a way to safely determine if a given Oracle Database has Advanced Compression available.

Based on this information I want to enable Basic Compression or Advanced Compression for certain tables.

I tried querying v$version, which seems a bit awkward but works for identifying if an EE is installed. But so far I didn't find a way to see if Advanced Compression is available.

--0 => No EE
SELECT COUNT(*) 
 FROM v$version
  WHERE banner LIKE 'Oracle%Enterprise%';

Is there a way to determine if Advanced Compression is available?

Solution

  • You need to talk to your Oracle Account Manager and/or read the fine print on your Oracle License Agreements and Contracts.

    The software generally ships with all features available to use. Features are accessible based on what you paid for.

    If you don't know, assume you shouldn't use it.