RE: Oracle License for Optional Packs Question

From: <>
Date: Fri, 17 Nov 2017 21:03:38 +0000
Message-ID: <>

Advanced compression will also be triggered if someone issues an expdp command with the COMPRESSION option. We were bit by that once. The DBA who did it had no idea it was a license violation. Neither did anyone else until it suddenly showed up in dba_feature_usage_statistics.

Jay Miller
Sr. Oracle DBA

From: [] On Behalf Of Stefan Knecht Sent: Friday, November 17, 2017 12:51 AM To: Nagaraj S
Cc: dba oracle; oracle-l
Subject: Re: Oracle License for Optional Packs Question

The four options you are concerned with, can't be disabled. It would be simple for Oracle to implement a mechanisms to do so, but I suppose all the accidental violations that netted them money, outweigh the benefit of doing so.

Particularly advanced security or advanced compression are tricky because they can be used outside of the database as well (think Data Guard Redo Compression or RMAN backup compression, for example).

What I have seen some people do is run a job in the database that scans for objects that would violate their allowed functionality, and produce an alert when something was found. My framework, zztat, can also run checks like this.

If you have already found something inside the database that uses such functionality, the only way out is, as you have stated, a full export / import.



zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework! Visit us at<> | Support our Indiegogo campaign at<> | _at_zztat_oracle
-- Received on Fri Nov 17 2017 - 22:03:38 CET

Original text of this message