Home » Other » Marketplace » McOptions: a program which allows to know which options are used in a database (mcoptions_64.exe windows 2022 x64 Oracle 19c 19.17)
McOptions: a program which allows to know which options are used in a database [message #649263] Sun, 20 March 2016 11:35 Go to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I have posted a program in our Oracle licensing wiki page.
This is a Windows program which allows you to know the installed and used options and to immediately check these later ones.

The help is the following one:
C:\>McOptions -h

McOptions Utility by Michel Cadot: Version 2022.02.06

Copyright (c) Michel Cadot, 2016-2022. All rights reserved.

Usage: McOptions.exe [-h] [-f [-fr]] [-c [--disable option>[...]]] [-o] [-ro] [-v] [<l

with:
  { -c  | --check }      Checks now (requires SYSDBA privilege).
  { --disable <feature or option> }
                         Disables the checking of the specified feature or option
                         (ignored if "-c" is not given).
  { -f  | --features }   Displays the paying used features in addition to the options
  { -fr | --free }       Includes the free used features (this option implies "-f").
  { -h  | --help }       Displays the version and the usage help.
  { -o  | --options }    Displays installed options.
  { -ro | --root_only }  When connected to CDB$ROOT, displays root only
                           (this option is ignored in versions before 12c).
  { -v  | --verbose }    Displays additional information about patches:
                           registry history, patches list and, if connected as SYSDBA,
                           incompatibilities between a PDB and the CDB to which it bel
                           and PDB alerts.

and <logon> is:
  { <username>[/<password>][@<connect_identifier>]
  | /[@<connect_identifier>] }
  | <proxyuser>[<username>][/<password>][@<connect_identifier>]
  | [<username>]/[@<connect_identifier>] }
  [AS SYSDBA]
in the 2 lines before the last one, [] around <username> are real [] not syntactical
characters denoting an optional parameter. These lines refer to proxy connection.

The program shows the options and packs used in an Oracle instance/database.

* If the "-c" option is given, the program checks which features, options and packs
  are used in the current instance. This option requires an account with SYSDBA
  privilege (there is no need to specify "AS SYSDBA" in the <logon> parameter:
  McOptions tries anyway a connection "AS SYSDBA" if this option is given).
* The other program feature options require an account with the SELECT privilege on
  the V$DATABASE, V$OPTION, V$VERSION, GV$CELL_STATE, DBA_FEATURE_USAGE_STATISTICS
  and DBA_REGISTRY catalog views.
* The "-v" option requires in addition SELECT privilege on the DBA_REGISTRY_HISTORY,
  DBA_REGISTRY_SQLPATCH, PDB_PLUG_IN_VIOLATIONS and PDB_ALERTS catalog views,
  and the EXECUTE privilege on the DBMS_QOPATCH package.
* The program works for Oracle versions from 10gR2 to 21c.
* In 12c+ multitenant databases, if you are connected to the root container then the
  program gives information for all the containers you have access unless the option
  "-ro" is given.
* There can be several "--disable" parameters.

The program is provided as it is without any guarantees or warranty. Although the
author has attempted to find and correct any bugs in this free program, the author
is not responsible for any damage or losses of any kind caused by the use or misuse
of the program. The author is under no obligation to provide support, service,
corrections, or upgrades to this program.

You can freely use, copy and distribute this program but you can't modify it without
the permission of the author you can contact on http://www.orafaq.com
You can post your comments, ask for improvements, report bugs... on the program at
http://www.orafaq.com/forum/t/200328/
I encourage you to subscribe to this topic (link at top of the page) if you want to
be warned when a new version is released.
Here's an example of execution with the default option on a 19c database:
C:\>McOptions-64 michel/michel@mikj3db1

McOptions Utility by Michel Cadot: Version 2021.05.26

Copyright (c) Michel Cadot, 2016-2021. All rights reserved.

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Version 19.11.0.0.210420

Database MIKJ3 container MIKJ3DB1 instance mikj3 on myserver on 26-MAY-2021 18:06:15

Registered components
=====================

Component       Version         Status      Description
--------------- --------------- ----------- --------------------------------------------------
APEX            18.2.0.00.12    VALID       Oracle Application Express
APS             19.0.0.0.0      VALID       OLAP Analytic Workspace
CATALOG         19.0.0.0.0      VALID       Oracle Database Catalog Views
CATJAVA         19.0.0.0.0      VALID       Oracle Database Java Packages
CATPROC         19.0.0.0.0      VALID       Oracle Database Packages and Types
CONTEXT         19.0.0.0.0      VALID       Oracle Text
DV              19.0.0.0.0      VALID       Oracle Database Vault
JAVAVM          19.0.0.0.0      VALID       JServer JAVA Virtual Machine
OLS             19.0.0.0.0      VALID       Oracle Label Security
ORDIM           19.0.0.0.0      VALID       Oracle Multimedia
OWM             19.0.0.0.0      VALID       Oracle Workspace Manager
RAC             19.0.0.0.0      OPTION OFF  Oracle Real Application Clusters
SDO             19.0.0.0.0      VALID       Spatial
XDB             19.0.0.0.0      VALID       Oracle XML Database
XML             19.0.0.0.0      VALID       Oracle XDK
XOQ             19.0.0.0.0      VALID       Oracle OLAP API

SQL Patches
===========

Patch description                                       Patch UID Version       Flags Action   Status      Action time
------------------------------------------------------- ---------- ------------- ----- -------- ----------- -------------------
Windows Database Bundle Patch : 19.7.0.0.200414 (309013   23471163 19.1.0>19.7.0 N     APPLY    SUCCESS     2020/06/19 11:05:37
OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)           23504850 19.7.0>19.7.0 NJ    APPLY    SUCCESS     2020/06/19 15:23:32
OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)           23504850 19.8.0>19.8.0 NJ    ROLLBACK SUCCESS     2020/08/09 07:25:37
Windows Database Bundle Patch : 19.8.0.0.200714 (312476   23674370 19.7.0>19.8.0 N     APPLY    SUCCESS     2020/08/09 07:25:39
OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)           23690485 19.8.0>19.8.0 NJ    APPLY    SUCCESS     2020/08/09 08:11:01
OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)           23690485 19.11.>19.11. NJ    ROLLBACK SUCCESS     2021/05/20 18:01:16
Windows Database Bundle Patch : 19.11.0.0.210420 (32409   24073904 19.8.0>19.11. N     APPLY    SUCCESS     2021/05/20 18:01:20

Used options and packs
======================

Option or Pack                        Usage                 Detected usages
------------------------------------- --------------------- ---------------
Entreprise Edition (no option/pack)   Currently used                    163
Diagnostics Pack                      Currently used                     56
Multitenant                           Currently used                     32
Tuning Pack                           Currently used                     55 (requires Diagnostics Pack)
This is the minimal output you will get.
The program first displays the standard Oracle banner (from the server not the client):
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Version 19.11.0.0.210420
Then it displays a database specific banner:
Database MIKJ3 container MIKJ3DB1 instance mikj3 on myserver on 26-MAY-2021 18:06:15
Then the registered components with their version and status (these information come from DBA_REGISTRY view):
Component       Version         Status      Description
--------------- --------------- ----------- --------------------------------------------------
APEX            18.2.0.00.12    VALID       Oracle Application Express
APS             19.0.0.0.0      VALID       OLAP Analytic Workspace
CATALOG         19.0.0.0.0      VALID       Oracle Database Catalog Views
CATJAVA         19.0.0.0.0      VALID       Oracle Database Java Packages
CATPROC         19.0.0.0.0      VALID       Oracle Database Packages and Types
CONTEXT         19.0.0.0.0      VALID       Oracle Text
DV              19.0.0.0.0      VALID       Oracle Database Vault
JAVAVM          19.0.0.0.0      VALID       JServer JAVA Virtual Machine
OLS             19.0.0.0.0      VALID       Oracle Label Security
ORDIM           19.0.0.0.0      VALID       Oracle Multimedia
OWM             19.0.0.0.0      VALID       Oracle Workspace Manager
RAC             19.0.0.0.0      OPTION OFF  Oracle Real Application Clusters
SDO             19.0.0.0.0      VALID       Spatial
XDB             19.0.0.0.0      VALID       Oracle XML Database
XML             19.0.0.0.0      VALID       Oracle XDK
XOQ             19.0.0.0.0      VALID       Oracle OLAP API
Then, in versions 12c and up, the SQL or database patches (these information come from the DBA_REGISTRY_SQLPATCH, see the Oracle Reference book for an explaination of the columns):
Patch description                                       Patch UID Version       Flags Action   Status      Action time
------------------------------------------------------- ---------- ------------- ----- -------- ----------- -------------------
Windows Database Bundle Patch : 19.7.0.0.200414 (309013   23471163 19.1.0>19.7.0 N     APPLY    SUCCESS     2020/06/19 11:05:37
OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)           23504850 19.7.0>19.7.0 NJ    APPLY    SUCCESS     2020/06/19 15:23:32
OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)           23504850 19.8.0>19.8.0 NJ    ROLLBACK SUCCESS     2020/08/09 07:25:37
Windows Database Bundle Patch : 19.8.0.0.200714 (312476   23674370 19.7.0>19.8.0 N     APPLY    SUCCESS     2020/08/09 07:25:39
OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)           23690485 19.8.0>19.8.0 NJ    APPLY    SUCCESS     2020/08/09 08:11:01
OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)           23690485 19.11.>19.11. NJ    ROLLBACK SUCCESS     2021/05/20 18:01:16
Windows Database Bundle Patch : 19.11.0.0.210420 (32409   24073904 19.8.0>19.11. N     APPLY    SUCCESS     2021/05/20 18:01:20
And in the end the used options. The last 2 columns are similar to the CURRENTLY_USED/LAST_USAGE_DATE and DETECTED_USAGES columns of the DBA_FEATURE_USAGE_STATISTICS view.
"Currently used" is currently used in Oracle meaning that is it was in use the last time Oracle checked.

You can see which features are used to justify these options using the "-f" option ("EE" means "Enterprise Edition") (common minimal output has been removed and noted <...>):
C:\>McOptions-64 -f michel/michel@mikj3db1

McOptions Utility by Michel Cadot: Version 2021.05.26

<...>

Used features
=============

Feature                                                EE  Option or Pack              Usage Comment
------------------------------------------------------ --- ------------------------- ------- --------------------------------
Adaptive Plans                                         Yes                                32 Currently used
Automatic Maintenance - SQL Tuning Advisor             Yes Tuning Pack                    22 Last: 2021/01/13
control_management_pack_access DIAGNOSTIC              Yes Diagnostics Pack                1 Currently used
control_management_pack_access TUNING                  Yes Tuning Pack                     1 Currently used
Deferred Segment Creation                              Yes                                32 Currently used
Oracle Multitenant                                     Yes Multitenant                    32 Currently used
Oracle Utility Datapump (Export)                       Yes                                 2 Last: 2020/06/07
Parallel SQL Query Execution                           Yes                                32 Currently used
Result Cache                                           Yes                                32 Currently used
SQL Plan Directive                                     Yes Tuning Pack                    32 Currently used
SQL Tuning Set (system)                                Yes                                32 Currently used
Streams (user)                                         Yes                                 1 Currently used
Tuning Pack                                            Yes Diagnostics Pack               55 Currently used
In addition, if you want to see which free features you used you can give the "--free" option:
C:\>McOptions-64 --free michel/michel@mikj3db1

McOptions Utility by Michel Cadot: Version 2021.05.26

<...>

Used features
=============

EE  Option or Pack            Feature                                                  Usage Comment
--- ------------------------- ------------------------------------------------------ ------- --------------------------------
No                            Automatic Maintenance - Optimizer Statistics Gathering      23 Currently used
No                            Automatic Maintenance - Space Advisor                       23 Currently used
No                            Automatic Reoptimization                                    32 Currently used
No                            Automatic Segment Space Management (system)                 32 Currently used
No                            Automatic Segment Space Management (user)                   32 Currently used
No                            Automatic SQL Execution Memory                              32 Currently used
No                            Automatic Undo Management                                   32 Currently used
No                            Character Semantics                                         32 Currently used
No                            Character Set                                               32 Currently used
No                            Extensibility                                                8 Currently used
No                            Index Organized Tables                                       1 Currently used
No                            Job Scheduler                                               32 Currently used
No                            LOB                                                         32 Currently used
No                            Locally Managed Tablespaces (system)                        32 Currently used
No                            Locally Managed Tablespaces (user)                          32 Currently used
No                            Logfile Multiplexing                                        32 Currently used
No                            Object                                                      27 Currently used
No                            Oracle Call Interface (OCI)                                  3 Last: 2020/05/31
No                            Oracle Java Virtual Machine (system)                        32 Currently used
No                            Oracle Java Virtual Machine (user)                          27 Currently used
No                            Oracle Utility Metadata API                                  5 Last: 2020/06/15
No                            Partitioning (system)                                       32 Currently used
No                            Recovery Area                                               32 Currently used
No                            Recovery Manager (RMAN)                                      2 Last: 2020/11/08
No                            RMAN - Disk Backup                                           2 Last: 2020/11/08
No                            SecureFiles (system)                                        32 Currently used
No                            SecureFiles (user)                                          32 Currently used
No                            Server Parameter File                                       32 Currently used
No                            Services                                                    32 Currently used
No                            SQL Plan Management                                         23 Currently used
No                            SQL*Plus                                                     2 Last: 2020/08/28
No                            Statistics Advisor                                          29 Currently used
No                            Streams (user)                                               1 Currently used
No                            Traditional Audit                                           32 Currently used
No                            Unified Audit                                               32 Currently used

Yes                           Adaptive Plans                                              32 Currently used
Yes                           Deferred Segment Creation                                   32 Currently used
Yes                           Parallel SQL Query Execution                                32 Currently used
Yes                           Result Cache                                                32 Currently used
Yes                           SQL Tuning Set (system)                                     32 Currently used
Yes                           Streams (user)                                               1 Currently used
Yes Diagnostics Pack          control_management_pack_access DIAGNOSTIC                    1 Currently used
Yes Diagnostics Pack          Tuning Pack                                                 55 Currently used
Yes Multitenant               Oracle Multitenant                                          32 Currently used
Yes Tuning Pack               Automatic Maintenance - SQL Tuning Advisor                  22 Last: 2021/01/13
Yes Tuning Pack               control_management_pack_access TUNING                        1 Currently used
Yes Tuning Pack               SQL Plan Directive                                          32 Currently used
The previous information come and are aggregated from the DBA_FEATURE_USAGE_STATISTICS view.

Now the program can immediately check the currently used options and features using the "-c" option:
C:\>McOptions-64 -c michel/michel@mikj3db1

McOptions Utility by Michel Cadot: Version 2021.05.26

<...>

Options currently used
======================

Entreprise Edition (no option/pack) -----> Adaptive Plans
                                           Deferred Segment Creation
                                           Parallel SQL Query Execution
                                           Result Cache
                                           SQL Tuning Set (system)
                                           Streams (user)
Diagnostics Pack ------------------------> control_management_pack_access DIAGNOSTIC
                                           Tuning Pack
Multitenant -----------------------------> Oracle Multitenant
                                           Oracle Pluggable Databases
Tuning Pack -----------------------------> control_management_pack_access TUNING
                                           SQL Plan Directive
                                           SQL Plan Management
The format is: <the option or pack used> ---> <the used feature that justifies this option>.
"Options currently used" here are options really currently used not the same than the "Currently used" of the previous chart which, I repeat, means used when Oracle checked it the last time.
Note: the "-c" option requires an account with SYSDBA privilege (it is then not needed to specify AS SYSDBA in the <logon> parameter).

In the end, if you want to know which options are installed you can use the "-o" option (this information is directly gotten from the V$OPTION view):
C:\>McOptions-64 -o michel/michel@mikj3db1

McOptions Utility by Michel Cadot: Version 2021.05.26

Copyright (c) Michel Cadot, 2016-2021. All rights reserved.

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Version 19.11.0.0.210420

Database MIKJ3 container MIKJ3DB1 instance mikj3 on myserver on 26-MAY-2021 18:12:56

Installed options
=================

Active Data Guard
Adaptive Execution Plans
Advanced Analytics
Advanced Compression
Advanced Index Compression
Advanced replication
Application Role
Automatic Data Optimization
Backup Encryption
Basic Compression
Bit-mapped indexes
Block Change Tracking
Block Media Recovery
Cache Fusion Lock Accelerator
Centrally Managed User
Change Data Capture
Coalesce Index
Connection multiplexing
Connection pooling
Cross Transportable Backups
DICOM
Data Mining
Data Redaction
Database queuing
Database resource manager
Deferred Segment Creation
Duplexed backups
Enterprise User Security
Exadata Discovery
Export transportable tablespaces
Fast-Start Fault Recovery
File Mapping
Fine-grained Auditing
Fine-grained access control
Flashback Data Archive
Flashback Database
Flashback Table
Global Data Services
Heat Map
In-Memory Aggregation
In-Memory Column Store
Incremental backup and recovery
Instead-of triggers
Java
Join index
Managed Standby
Materialized view rewrite
OLAP
OLAP Window Functions
Objects
Online Index Build
Online Redefinition
Oracle Data Guard
Parallel backup and recovery
Parallel execution
Parallel load
Partitioning
Plan Stability
Point-in-time tablespace recovery
Privilege Analysis
Proxy authentication/authorization
Real Application Security
Real Application Testing
Result Cache
SQL Plan Management
Sample Scan
SecureFiles Encryption
Server Flash Cache
Snapshot time recovery
Spatial
Streams Capture
Table Clustering
Transparent Application Failover
Transparent Data Encryption
Transparent Sensitive Data Protection
Trial Recovery
Unused Block Compression
XStream
Zone Maps

<...>

Note: McOptions is written for "On-Premise" systems and does not check for "Cloud" systems specific features, options or packs, then it associates features with XE, PE, SE* or EE editions and not with DBCS* or ExaCS* ones.

Note: McOptions cannot determine if the option is mandatory or not in some very specific cases; in these cases when it detects the use of the objects it reports as a used feature with the associated option or pack.
For instance, in the following cases (extract from 19c Licensing Manual, underlining is mine):
Quote:
If you are licensed for the on-premise Oracle Database Enterprise Edition, then you can use certain subprograms of the DBMS_SQLTUNE package even if you do not have an Oracle Tuning Pack license.
Quote:
Some data in DBA_STREAMS_TP_COMPONENT_STAT requires Oracle Diagnostics Pack. The following filter clause to any query on DBA_STREAMS_TP_COMPONENT_STAT shows Diagnostics-Pack-dependent data:
where STATISTIC_UNIT = 'PERCENT'

Note: McOptions does not take into account some restricted use licenses included in other ones; in these cases when it detects the use of the features it reports them as a used option or pack.
For instance (extract from 19c Licensing Manual):
Quote:
Oracle Label Security includes a restricted use license for the following Oracle Enterprise Manager features:
• Application Data Models (previously called Data Discovery and Modeling)
• Sensitive Column Types and Sensitive Data Discovery
• Application Accelerators
If you want to use the Oracle Enterprise Manager features listed above not solely for the purposes of Oracle Label Security, then you must purchase a full-use license for Oracle Data Masking and Subsetting Pack.

References initially used:
Oracle® Database Licensing Information 10g Release 2 (10.2) B14199-28 (June 2014, final version)
Oracle® Database Licensing Information 11g Release 2 (11.2) E47877-05 (September 2014)
Oracle® Database Licensing Information 12c Release 1 (12.1) E49208-10 (May 2015)

Latest references used:
Oracle® Database Licensing Information 10g Release 2 (10.2) B14199-28 (June 2014, final version)
Oracle® Database Licensing Information 11g Release 2 (11.2) E47877-11 (December 2016, final version)
Oracle® Database Licensing Information User Manual 12c Release 1 (12.1) E49208-26 (April 2020, final version)
Oracle® Database Licensing Information User Manual 12c Release 2 (12.2) E85683-23 (September 2021)
Oracle® Database Licensing Information User Manual 18c E87202-26 (September 2021)
Oracle® Database Licensing Information User Manual 19c E94254-30 (September 2021)
Oracle® Database Licensing Information User Manual 21c F31218-13 (November 2021)

Latest version: 2022.02.06, download in Oracle licensing wiki page
32-bit: 
  MD5:   b8143c7d5ecb2f82c4521387dadbd6f8
  SHA-1: f5ea6463be6ddbb9d00007f870252370d0fbaaf2
64-bit: 
  MD5:   44915396918f4c68b60801c3917d3f32
  SHA-1: ea3a99178247587c034f553f00d79a8d0bce153c

[Updated on: Sun, 06 February 2022 11:06]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #650472 is a reply to message #649263] Tue, 26 April 2016 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Updated today with the latest licensing information including 12.1.0.2:

Oracle® Database Licensing Information 11g Release 2 (11.2) E47877-07 (February 2016)
Oracle® Database Licensing Information User Manual 12c Release 1 (12.1) E49208-14 (February 2016)

Note: if you have not the privileges to get the information you will receive the following message:
*** ORA-00942: table or view does not exist

[Updated on: Tue, 26 April 2016 04:13]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #655197 is a reply to message #650472] Wed, 24 August 2016 10:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

McOptions now supports proxy connection.

Re: McOptions: a program which allows to know which options are used in a database [message #655237 is a reply to message #649263] Thu, 25 August 2016 09:40 Go to previous messageGo to next message
willnb10
Messages: 5
Registered: August 2016
Junior Member
Hi,

I tried you program but got the following error while executing on Windows Server 2008 R2 Standard with Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

>McOptions -h
Can't load 'C:\Users\ADMINI~1\AppData\Local\Temp\1\par-41646d696e6973747261746f72\cache-7e846778ce271777bc26b67bd2b9ffb5919f1f3e\051dbf
e5.dll' for module DBD::Oracle: load_file:%1 is not a valid Win32 application at C:\Perl\lib/DynaLoader.pm line 194.
at C:/Perl/site/lib/PAR/Heavy.pm line 120.
Compilation failed in require at script/McOptions.pl line 19.
BEGIN failed--compilation aborted at script/McOptions.pl line 19.

Any prerequisite I'm missing ?
Re: McOptions: a program which allows to know which options are used in a database [message #655239 is a reply to message #655237] Thu, 25 August 2016 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

First let us try removing all your possible Perl settings: %PERL5LIB, Perl in %PATH...
Just keep Windows and Oracle stuff in PATH.
Set %ORACLE_HOME* variables as needed.
Try.
What happens?

Re: McOptions: a program which allows to know which options are used in a database [message #655240 is a reply to message #655239] Thu, 25 August 2016 10:05 Go to previous messageGo to next message
willnb10
Messages: 5
Registered: August 2016
Junior Member
I have no Perl in Path and ORACLE_HOME is set correctly.
Re: McOptions: a program which allows to know which options are used in a database [message #655241 is a reply to message #655240] Thu, 25 August 2016 10:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please post the result of
SET
DIR C:\Perl
(Remove COMPUTERNAME, USERDOMAIN or any confidential variables.)
Do you use a local or a domain user?

Re: McOptions: a program which allows to know which options are used in a database [message #655243 is a reply to message #655241] Thu, 25 August 2016 10:50 Go to previous messageGo to next message
willnb10
Messages: 5
Registered: August 2016
Junior Member
what precise environment variable do you want me to show ?
C:\Perl does not exist
Re: McOptions: a program which allows to know which options are used in a database [message #655247 is a reply to message #655243] Thu, 25 August 2016 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

All of them to see if there is any incompatibility.
Please don't tell, copy and paste.


Re: McOptions: a program which allows to know which options are used in a database [message #655293 is a reply to message #655247] Fri, 26 August 2016 02:31 Go to previous messageGo to next message
willnb10
Messages: 5
Registered: August 2016
Junior Member
Here is the result
Toggle Spoiler
Re: McOptions: a program which allows to know which options are used in a database [message #655297 is a reply to message #655293] Fri, 26 August 2016 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

One thing puzzles me: you said: "Windows Server 2008 R2 Standard with Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" and your processors are 32bit.

I think the problem is that it does not find OCI.DLL, didn't have you a popup Windows when you executed McOptions?
Find the DLL and add its path into PATH variable.


Re: McOptions: a program which allows to know which options are used in a database [message #655298 is a reply to message #655297] Fri, 26 August 2016 03:41 Go to previous messageGo to next message
willnb10
Messages: 5
Registered: August 2016
Junior Member
My processor is 64 bit.
>wmic os get osarchitecture
OSArchitecture
64-bit

No popup was shown.
oci.dll is in %ORACLE_HOME%\bin that already is in my PATH variable.

Do you share your source code somewhere ?

[Updated on: Fri, 26 August 2016 03:41]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #655299 is a reply to message #655298] Fri, 26 August 2016 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
My processor is 64 bit.
Oh yes, misread the lines, sorry. /forum/fa/1606/0/

Quote:
oci.dll is in %ORACLE_HOME%\bin that already is in my PATH variable.
OK, so the error: "load_file:%1 is not a valid Win32", I need 32bit OCI.DLL.

Quote:
Do you share your source code somewhere ?
No (and it won't help you in this case.)

A quick workaround is to install a 32bit client (in a separate home and directory than your current install) and set this environment to use the program.

Re: McOptions: a program which allows to know which options are used in a database [message #656366 is a reply to message #655299] Tue, 04 October 2016 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

McOptions now supports 64-bit client.
There are actually 2 downloads, one for 32-bit and one for 64-bit (see link in first post).

Re: McOptions: a program which allows to know which options are used in a database [message #661156 is a reply to message #656366] Thu, 09 March 2017 04:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Changes in the new version are the following ones:
  • Fix minor bugs in all versions
  • Several improvements in all versions
  • Support of multitenant databases in 12c: if you connect to root container, McOptions returns you the information about all containers
  • Updated today with the latest licensing information:
    Oracle® Database Licensing Information 11g Release 2 (11.2) E47877-11 (December 2016)
    Oracle® Database Licensing Information User Manual 12c Release 1 (12.1) E49208-20 (December 2016)
Next step: Support of 12.2.

[Updated on: Thu, 09 March 2017 04:24]

Report message to a moderator

icon4.gif  Re: McOptions: a program which allows to know which options are used in a database [message #664473 is a reply to message #649263] Wed, 19 July 2017 17:17 Go to previous messageGo to next message
ridham
Messages: 1
Registered: July 2017
Junior Member
I ran this utility against 12.1.0.2 database with "-c" option and I got following error message:
DEBUG: Real-Time SQL Monitoring
DEBUG: SELECT used, sofar_exec, dbf_clob
         FROM   (SELECT count(*) used
                 FROM   dba_sql_monitor_usage
                 WHERE  num_db_reports > 0 AND
                        last_db_report_time >=  (select nvl(max(last_sample_date
), sysdate-7) from wri$_dbu_usage_sample) ),
                (SELECT num_db_reports sofar_exec,
                        xmlelement("sqlmon_usage",
                         xmlelement("num_em_reports", num_em_reports),
                         xmlelement("first_db_report_time",
                           to_char(first_db_report_time,
                                   'dd-mon-yyyy hh24:mi:ss')),
                         xmlelement("last_db_report_time",
                           to_char(last_db_report_time,
                                   'dd-mon-yyyy hh24:mi:ss')),
                         xmlelement("first_em_report_time",
                           to_char(first_em_report_time,
                                   'dd-mon-yyyy hh24:mi:ss')),
                         xmlelement("last_em_report_time",
                           to_char(last_em_report_time,
                                   'dd-mon-yyyy hh24:mi:ss'))
                        ).getClobVal(2,2) dbf_clob
                FROM dba_sql_monitor_usage)
DEBUG: ORA-01422: exact fetch returns more than requested number of rows
DEBUG: Real-Time SQL Monitoring

Please update the query appropriately...

FYI - when I executed this SQL in the database, I got following result:

SQL> set lines 200
SQL> SELECT used, sofar_exec, dbf_clob
         FROM   (SELECT count(*) used
               2      FROM   dba_sql_monitor_usage
  3    4                   WHERE  num_db_reports > 0 AND
                        last_db_report_time >=  (select nvl(max(last_sample_date
), sysdate-7) from wri$_dbu_usage_sample) ),
  5                  (SELECT num_db_reports sofar_exec,
                        xmlelement("sqlmon_usage",
  6                           xmlelement("num_em_reports", num_em_reports),
                         xmlelement("first_db_report_time",
  7    8    9   10   11                             to_char(first_db_report_time,
                                   'dd-mon-yyyy hh24:mi:ss')),
                         xmlelement("last_db_report_time",
                           to_char(last_db_report_time,
                                   'dd-mon-yyyy hh24:mi:ss')),
                         xmlelement("first_em_report_time",
                           to_char(first_em_report_time,
                                   'dd-mon-yyyy hh24:mi:ss')),
 12   13   14   15   16   17   18   19                           xmlelement("last_em_report_time",
                           to_char(last_em_report_time,
                                   'dd-mon-yyyy hh24:mi:ss'))
                        ).getClobVal(2,2) dbf_clob
                FROM dba_sql_monitor_usage) 20   21   22   23  ;

      USED SOFAR_EXEC DBF_CLOB
---------- ---------- --------------------------------------------------------------------------------
         3        280 <sqlmon_usage>
                        <num_em_reports>0</num_em_reports>
                        <first_db_report_time>04-a

         3        280 <sqlmon_usage>
                        <num_em_reports>0</num_em_reports>
                        <first_db_report_time>04-a

         3        280 <sqlmon_usage>
                        <num_em_reports>0</num_em_reports>
                        <first_db_report_time>04-a
Re: McOptions: a program which allows to know which options are used in a database [message #664475 is a reply to message #664473] Thu, 20 July 2017 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the information, I will investigate it as soon as possible.
Re: McOptions: a program which allows to know which options are used in a database [message #664513 is a reply to message #664473] Thu, 20 July 2017 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The problem came from a bug in an Oracle view, code has been fixed to workaround it.

Other changes in the new version are the following ones:
  • Fix minor bugs in all versions
  • Updated with the latest licensing information:
    Oracle® Database Licensing Information User Manual 12c Release 1 (12.1) E49208-22 (June 2017)
Next step: Support of 12.2.

[Updated on: Tue, 05 September 2017 11:15]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #665436 is a reply to message #664513] Tue, 05 September 2017 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version with the following changes:
  • Add option "-ro" for "root only" when connected to CDB$ROOT (see help in first post)
  • Add synonyms to program parameters (see help in first post)
  • Add registered components in default display (see example in first post)
  • Add SQL/database patches for 12.1+ versions (see example in first post)
  • Add support of version 12.2 using E49729-17 book (May 2017)
  • Because of bug 23734270 with no workaround (wrong/unavailable data in dictionary), ignore "Real-Time SQL Monitoring" feature in 12.*

[Updated on: Tue, 05 September 2017 11:17]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #668495 is a reply to message #655237] Tue, 27 February 2018 12:43 Go to previous messageGo to next message
brian5
Messages: 4
Registered: February 2018
Junior Member
I have this same error. Is this a proxy issue? I am behind a firewall at work.

Thanks,
Brian
Re: McOptions: a program which allows to know which options are used in a database [message #668496 is a reply to message #668495] Tue, 27 February 2018 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please copy and paste the result of:
McOptions -h
(Please read How to use [code] tags and make your code easier to read.)

[Updated on: Tue, 27 February 2018 12:57]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #668506 is a reply to message #668496] Tue, 27 February 2018 13:53 Go to previous messageGo to next message
brian5
Messages: 4
Registered: February 2018
Junior Member
C:\OraUtils>mcoptions-64 -h
Can't load 'C:\Users\NBKSFY5\AppData\Local\Temp\par-6e626b73667935\cache-e5967299b6520f79be6315decc89f8f452a499e0\c70e412f.dll' for module DBD::Oracle: load_file:The specified module could not be found at C:\Perl64\lib/DynaLoader.pm line 194.
at C:/Perl64/site/lib/PAR/Heavy.pm line 120.
Compilation failed in require at script/McOptions.pl line 35.
BEGIN failed--compilation aborted at script/McOptions.pl line 35.

I don't have a have a c:\perl64\ directory. I looked at McOptions and couldn't see anything on a requirement for that. Maybe I missed that?

Thanks
Re: McOptions: a program which allows to know which options are used in a database [message #668507 is a reply to message #668506] Tue, 27 February 2018 14:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please post the 20 first lines of:
SYSTEMINFO
Re: McOptions: a program which allows to know which options are used in a database [message #668508 is a reply to message #668507] Tue, 27 February 2018 14:13 Go to previous messageGo to next message
brian5
Messages: 4
Registered: February 2018
Junior Member
Host Name: KDC4A3E7Y22B2
OS Name: Microsoft Windows 10 Enterprise
OS Version: 10.0.10586 N/A Build 10586
OS Manufacturer: Microsoft Corporation
OS Configuration: Member Workstation
OS Build Type: Multiprocessor Free
Registered Owner: Bank
Registered Organization: Bank
Product ID: 00329-00000-00003-AA515
Original Install Date: 1/3/2017, 2:03:59 PM
System Boot Time: 2/27/2018, 7:51:37 AM
System Manufacturer: Hewlett-Packard
System Model: HP Z640 Workstation
System Type: x64-based PC
Processor(s): 2 Processor(s) Installed.
[01]: Intel64 Family 6 Model 79 Stepping 1 GenuineIntel ~1200 Mhz
[02]: Intel64 Family 6 Model 79 Stepping 1 GenuineIntel ~1200 Mhz
BIOS Version: Hewlett-Packard M60 v02.23, 7/22/2016
Windows Directory: C:\WINDOWS
System Directory: C:\WINDOWS\system32
Boot Device: \Device\HarddiskVolume1
System Locale: en-us;English (United States)
Input Locale: en-us;English (United States)
Time Zone: (UTC-05:00) Eastern Time (US & Canada)
Total Physical Memory: 16,300 MB
Available Physical Memory: 8,179 MB
Virtual Memory: Max Size: 32,684 MB
Virtual Memory: Available: 21,916 MB
Virtual Memory: In Use: 10,768 MB
Page File Location(s): C:\pagefile.sys
Re: McOptions: a program which allows to know which options are used in a database [message #668510 is a reply to message #668508] Tue, 27 February 2018 14:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, now post the result of:
SET
Re: McOptions: a program which allows to know which options are used in a database [message #668513 is a reply to message #668510] Tue, 27 February 2018 14:35 Go to previous messageGo to next message
brian5
Messages: 4
Registered: February 2018
Junior Member
Michael,

I feel so stupid. It's the PATH setting. Oracle Client 12.2 installation did not update the path correctly and it's not finding the ....\bin\ directory.

We are restricted from changing the PATH permanently but, when I set the PATH correctly and then run McOptions, it's working just fine.

Thanks for your time,
Brian
Re: McOptions: a program which allows to know which options are used in a database [message #668514 is a reply to message #668513] Tue, 27 February 2018 14:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Glad it is not a more complex problem and it now works for you. Smile

Re: McOptions: a program which allows to know which options are used in a database [message #672813 is a reply to message #665436] Sun, 28 October 2018 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version with the following changes:
  • Add option "--disable" (see help in first post and below)
  • Updated with the latest licensing information:
    Oracle® Database Licensing Information User Manual 12c Release 1 (12.1) E49208-23 (May 2018)
    Oracle® Database Licensing Information User Manual 12c Release 2 (12.2) E85683-04 (August 2018)
  • Apply fix for bug 1993134.1 in the code
  • Code for option "-c" has been completely rewritten; now the program executes, whatever is your patch level, either the code of the latest PSU at the time McOptions is delivered (currently PSU 181016) or the code of your database if it is newer; more, it backports the code of the latest versions to the previous ones when appropriate so you have fixes on versions that are no more updated by Oracle
Sometimes "-c" option aborts with an error in the OCI layer and then you have not the result of the checking. This has been discovered in 10g for features "Change Data Capture" and "Oracle Database Vault" but may happen in other cases.
The new option "--disable" has been introduced to prevent from this as you can disable the checking of the features or options that lead to this error in your case.
You can give several "--disable" options on the command line.

[Updated on: Tue, 30 October 2018 07:02]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #672874 is a reply to message #672813] Tue, 30 October 2018 05:21 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Am I the only one who thinks that McOptions might be something offered to you in a fast-food restaurant? Wink
Re: McOptions: a program which allows to know which options are used in a database [message #673581 is a reply to message #672813] Mon, 26 November 2018 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

McOptions now supports Oracle version 18c.

[Updated on: Mon, 26 November 2018 10:06]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #681229 is a reply to message #673581] Sat, 27 June 2020 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version (2020.06.27) with the following changes:
  • Support of Oracle version 19c with licensing information from:
    Oracle® Database Licensing Information User Manual 19c E94254-18 (April 2020)
  • Update the previous versions with the latest licensing information:
    Oracle® Database Licensing Information User Manual 12c Release 1 (12.1) E49208-26 (April 2020)
    Oracle® Database Licensing Information User Manual 12c Release 2 (12.2) E85683-16 (April 2020)
    Oracle® Database Licensing Information User Manual 18c E87202-18 (April 2020)
  • Improve the previous versions, for instance check the control_management_pack_access init.ora parameter
  • Fix a couple of minor bugs
  • New option "-v" or "--verbose" which gives the following information (if you are allowed to get it) (see example below):
    • registry history
    • list of patches
    • PDB violations and alerts
Verbose option
Here's an example of use of the verbose option:
C:\>McOptions-64 -ro -v michel/michel

McOptions Utility by Michel Cadot: Version 2020.06.27

Copyright (c) Michel Cadot, 2016-2020. All rights reserved.

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options

Database MIKJ3 container CDB$ROOT instance mikj3 on arda on 27-JUN-2020 17:17:26

Component       Version         Status      Description
--------------- --------------- ----------- --------------------------------------------------
APEX            18.2.0.00.12    VALID       Oracle Application Express
APS             19.0.0.0.0      VALID       OLAP Analytic Workspace
CATALOG         19.0.0.0.0      VALID       Oracle Database Catalog Views
CATJAVA         19.0.0.0.0      VALID       Oracle Database Java Packages
CATPROC         19.0.0.0.0      VALID       Oracle Database Packages and Types
CONTEXT         19.0.0.0.0      VALID       Oracle Text
DV              19.0.0.0.0      VALID       Oracle Database Vault
JAVAVM          19.0.0.0.0      VALID       JServer JAVA Virtual Machine
OLS             19.0.0.0.0      VALID       Oracle Label Security
ORDIM           19.0.0.0.0      VALID       Oracle Multimedia
OWM             19.0.0.0.0      VALID       Oracle Workspace Manager
RAC             19.0.0.0.0      OPTION OFF  Oracle Real Application Clusters
SDO             19.0.0.0.0      LOADING     Spatial
XDB             19.0.0.0.0      VALID       Oracle XML Database
XML             19.0.0.0.0      VALID       Oracle XDK
XOQ             19.0.0.0.0      VALID       Oracle OLAP API

Operation time   Operation    Space     Version           Patch Comments
---------------- ------------ --------- --------------- ------- ------------------------------------------------------------
                 BOOTSTRAP    DATAPATCH 19                      RDBMS_19.3.0.0.0DBRU_WINDOWS.X64_190528
2020/06/19 10:59 RU_APPLY     SERVER    19.0.0.0.0              Patch applied from 19.3.0.0.0 to 19.7.0.0.0: Release_Update
2020/06/19 15:22 jvmpsu.sql   SERVER    19.7.0.0.200414       0 RAN jvmpsu.sql
2020/06/19 15:22 APPLY        SERVER    19.7.0.0.200414       0 OJVM RU post-install

Patch description                                       Patch UID Version       Flags Action   Status      Action time
------------------------------------------------------- ---------- ------------- ----- -------- ----------- -------------------
Windows Database Bundle Patch : 19.7.0.0.200414 (309013   23471163 19.1.0>19.7.0 N     APPLY    SUCCESS     19/06/2020 11:05:29
OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)           23504850 19.7.0>19.7.0 NJ    APPLY    SUCCESS     19/06/2020 15:23:32


Patch Id : 30901317
        Action : APPLY
        Action Time : 19-JUN-2020 11:05:29
        Description : Windows Database Bundle Patch : 19.7.0.0.200414 (30901317)
        Logfile : D:\Oracle2\cfgtoollogs\sqlpatch\30901317\23471163/30901317_apply_MIKJ3_CDBROOT_2020Jun19_10_55_54.log
        Status : SUCCESS

Patch Id : 30805684
        Action : APPLY
        Action Time : 19-JUN-2020 15:23:32
        Description : OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)
        Logfile : D:\Oracle2\cfgtoollogs\sqlpatch\30805684\23504850/30805684_apply_MIKJ3_CDBROOT_2020Jun19_15_21_01.log
        Status : SUCCESS

==> No PDB alerts

Option or Pack                        Usage                 Detected usages
------------------------------------- --------------------- ---------------
Entreprise Edition (no option/pack)   Currently used                     40
Diagnostics Pack                      Currently used                     32
Multitenant                           Currently used                     10
Tuning Pack                           Currently used                     31 (requires Diagnostics Pack)
The verbose option adds the following parts:
  • The registry history which is the chart with first column "Operation time" giving the operation, its type ("Space" column), its version and some comments
  • The list of the patches (each section starting with "Patch Id :") with the patch id, the action and action time, the description of the patch, its log file and status
  • The PDB alerts (empty here)
An example of PDB alerts is (from another database):
Operation time   Type       Error Status    Cause
---------------- --------- ------ --------- ---------------------------------------------------------------------------------
PDBs                                        Action
------------------------------------------- ---------------------------------------------------------------------------------
Message
-----------------------------------------------------------------------------------------------------------------------------
2016/10/20 19:48 WARNING        0 RESOLVED  missing XDB schema type
MIKCDB1,MIKCDB2                             Please execute xdb.DBMS_XMLSTORAGE_MANAGE.GetTypeDDL
There are common XDB schema types missing from ROOT.
=============================================================================================================================
2018/10/23 10:35 ERROR          0 RESOLVED  SQL Patch
PDB$SEED                                    Call datapatch to install in the PDB or the CDB
PSU bundle patch 160719 (WINDOWS DB BUNDLE PATCH 12.1.0.2.160719(64bit):23530387): Installed in the CDB but not in the PDB.
This chart gives the time of the operation, the type of alert, the error if applicable, the status of the alert (changed to RESOLVED when the appropriate action has been taken), its cause, the PDBs it concerns, the action to solve the alert, and a descriptive message.

[Updated on: Mon, 18 January 2021 11:02]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #684406 is a reply to message #681229] Wed, 26 May 2021 12:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version (2021.05.27) with the following changes:
  • Update with the latest licensing information:
    Oracle® Database Licensing Information User Manual 12c Release 2 (12.2) E85683-20 (April 2021)
    Oracle® Database Licensing Information User Manual 18c E87202-22 (April 2021)
    Oracle® Database Licensing Information User Manual 19c E94254-26 (April 2021)
  • Improvements in the ouput:
    • All dates are now in the format YYYY/MM/DD, maybe followed by a time
    • A title has been added before each chart
    • ...
  • Fix minor bugs and workaround Oracle ones
Note: The 12c Release 1 was in its final version in the previous update.

There are few modifications since the previous update however I want to point out a new free option introduced in 19c, version 19.8, Enterprise Edition: "Database In-Memory Base Level".

Quote:
[This option] Allows you to experiment with Oracle Database In-Memory features without
purchasing the Oracle Database In-Memory option.
The following restrictions apply:
  • The size of the In-Memory area (INMEMORY_SIZE) cannot exceed 16 GB for a CDB.
    In an Oracle RAC environment, the size is limited to 16 GB for each instance.
  • The compression level for all objects and columns is automatically and transparently set to QUERY LOW.
  • The Automatic In-Memory feature is disabled.
  • In-Memory Column Store feature tracking is tracked for "In-Memory Base Level" rather than "In-Memory Column Store."
  • The CellMemory feature is disabled for Oracle Exadata.

This option is enabled by setting the parameter "inmemory_force" to "BASE_LEVEL" (default is... "DEFAuLT").
Note: Oracle code does not actually report the use of "In-Memory Base Level" option, McOptions does.

Note: The first post of this topic has been updated to clarify the scope and some restrictions of the program.

[Updated on: Mon, 27 September 2021 11:26]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #684436 is a reply to message #684406] Wed, 02 June 2021 13:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version (2021.06.02) with the following small changes:
  • Improvements in the code
  • Full Oracle version in the banner (see first post)

[Updated on: Wed, 02 June 2021 13:49]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #684919 is a reply to message #684436] Mon, 27 September 2021 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version (2021.09.27) with the latest licensing information:
  • Oracle® Database Licensing Information User Manual 12c Release 2 (12.2) E85683-23 (September 2021)
  • Oracle® Database Licensing Information User Manual 18c E87202-26 (September 2021)
  • Oracle® Database Licensing Information User Manual 19c E94254-30 (September 2021)
Re: McOptions: a program which allows to know which options are used in a database [message #684933 is a reply to message #684919] Tue, 28 September 2021 11:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version (2021.09.28)

Starting with 19.12, Oracle ported "Memoptimized Rowstore" and "In-Memory Column Store for External Tables" Exadata features on "On-Premise" systems (McOptions does not check for Exadata specific features, see first post of the topic).

Currently, Oracle embedded code on these systems does not verify the usage of these features, I included them in this version of McOptions.

Note: "In-Memory Column Store for External Tables" implies "In-Memory Column Store", so if you use the former, the later is also reported; both require "Database In-Memory" option (and Entreprise Edition).
"Memoptimized Rowstore" feature is part of the Entreprise Edition.

[Updated on: Tue, 28 September 2021 11:57]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #685247 is a reply to message #684933] Tue, 23 November 2021 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version (2021.11.23)

Update with PSU Oct-2021:
  • Fixes for bugs 28687851 and 31006259
  • For versions 19c onward, you no more need "Multitenant" option if you have at most 3 custom PDBs.
Next step: support of 21c.

McOptions: a program which allows to know which options are used in a database [message #685517 is a reply to message #649263] Wed, 26 January 2022 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I wish you a happy and healthy new year.

I'm currently rewriting McOptions to support all environments and not only "On-Premise" ones and better support these later ones when on Engineered Systems (Oracle Database Appliance and Exadata) currently not fully supported.
This new version will also allow you to simulate the options you have to buy if you choose another configuration or, if you want to downgrade to a lower configuration, if this is possible and under which conditions.

As I have not access to all possible configurations and want to be sure to give accurate information, I ask for your help, please execute the following script (also attached to this post), for any version from 10gR2 to 21c+, and PM me the spool file (PM button at the bottom left of this message):
set echo off feedback off heading off linesize 160 trimout on trimspool on pagesize 1000
col dt new_value dt
select to_char(systimestamp,'YYYYMMDDHH24MISSFF3') dt from dual
/
spool McOptions_&dt..txt
prompt
select banner from v$version where banner like 'Oracle%'
/
prompt
select banner_full from v$version
/
prompt
select 'ODA_INFRASTRUCTURE -> '||sys_context('SYS_CLUSTER_PROPERTIES','ODA_INFRASTRUCTURE') from dual
/
prompt
select 'ODA_TYPE -> '||sys_context('SYS_CLUSTER_PROPERTIES','ODA_TYPE') from dual
/
prompt
select 'EXADATA -> '||decode(count(*), 0,'NO', 'YES') from (select distinct cell_name from gv$cell_state)
/
prompt
set heading on feedback on
select distinct name features from dba_feature_usage_statistics order by 1
/
spool off
It does not matter if some queries return an error, it is even expected in some environments.
Note: you need the SELECT privileges on the queried views (v$version, gv$cell_state and dba_feature_usage_statistics) or the SELECT_CATALOG_ROLE role or the SELECT ANY DICTIONARY privilege.

Thank you for your cooperation.

  • Attachment: McOptions.sql
    (Size: 0.73KB, Downloaded 1626 times)

[Updated on: Mon, 31 January 2022 08:06]

Report message to a moderator

Re: McOptions: a program which allows to know which options are used in a database [message #685556 is a reply to message #685247] Sun, 06 February 2022 11:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

New version (2022.02.06)

Waiting for the new code, here's a version with the original one supporting 21c using Oracle® Database Licensing Information User Manual 21c F31218-13 (November 2021).

mcoptions PAR.pm error windows 2022 [message #687768 is a reply to message #649263] Tue, 30 May 2023 05:13 Go to previous messageGo to next message
Mulhmma
Messages: 9
Registered: May 2023
Junior Member
Hi,

I try to use mcoptions_64.exe on a server with windows 2022 but I get an error.
My commands :
   set ORACLE_SID=MYBASE
   mcoptions-64.exe -c -f -fr -o / as sysdba
It give me this error :
          PAR.pm did not return a true value at -e line 165.  

It's not the first time I ran mcoptions : it works without problem on servers 2012, 2019.
I like this program because it  makes quickly a simple report.

mcoptions_64.exe date : 06/02/2022 16:47

Could yo help me ? Thank you !

Best regards
Den

[Updated on: Tue, 30 May 2023 10:50] by Moderator

Report message to a moderator

Re: mcoptions PAR.pm error windows 2022 [message #687769 is a reply to message #687768] Tue, 30 May 2023 05:28 Go to previous messageGo to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Can you post the complete output as well as the result of:
set
Previous Topic: Devart Has Released a Major Update of dbForge Tools for MySQL
Next Topic: Explore the Oracle data dictionary with VISKey
Goto Forum:
  


Current Time: Thu Mar 28 08:06:03 CDT 2024