RE: Practice of using chopt to disable database options
- From: "Deas, Scott" <Scott.Deas@xxxxxxx>
- To: "fuzzy.graybeard@xxxxxxxxx" <fuzzy.graybeard@xxxxxxxxx>, Mark Bobak <Mark.Bobak@xxxxxxxxxxxx>
- Date: Fri, 15 Nov 2013 18:26:58 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Hans Forbrich
Sent: Friday, November 15, 2013 12:49 PM
To: Mark Bobak
Cc: oracle-l@xxxxxxxxxxxxx
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Š :-)
>
--
//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.**
Other related posts:
