RE: Practice of using chopt to disable database options

From: Deas, Scott <Scott.Deas_at_lfg.com>
Date: Fri, 15 Nov 2013 18:26:58 +0000
Message-ID: <C1FB7BA65B13C542B2CB1CE5DB8F74AF0694CD9E_at_NC2PWEX503.us.ad.lfg.com>

Oracle actually uses licensed options like partitioning behind the scenes in AWR (and maybe in other places), so by disabling the option, you could in fact be breaking other functionality. Some of the options are automatically installed, and it's easy to use them unintentionally, but you don't get charged just because they've been installed, only if they are currently in use (and I don't mean in use by core Oracle functionality that you have no control over).

Any time we've had an license review, we've provided output from DBA_FEATURE_USAGE_STATISTICS and V$OPTION and have never had any issue where they've tried to charge us for partitioning on a database where we've only licensed Diagnostics and Tuning, even though the AWR tables get partitioned (like WRH$_ACTIVE_SESSION_HISTORY).

Thanks,
Scott

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hans Forbrich Sent: Friday, November 15, 2013 12:49 PM To: Mark Bobak
Cc: oracle-l_at_freelists.org
Subject: Re: Practice of using chopt to disable database options

I agree, Mark.

Which is why I would love to see an official "If you don't install the option, the DB is not supported" doc.

One of the variants is: you may select to lay down the option in the Oracle Home when running 'software only' OUI, but then you may not select the option in the DBCA. Is that then 'installed'??

/Hans

On 15/11/2013 10:37 AM, Mark Bobak wrote:
> Hans,
>
> There seems to be a considerable level of contradiction in the
> documentation and in peoples¹ opinions, even some that work for
> OracleÐ :-)
>

--
http://www.freelists.org/webpage/oracle-l


Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^

Received on Fri Nov 15 2013 - 19:26:58 CET