概述
Oracle企业版功能使用情况检测,用于评估企业版,标准版对性能的影响范围,为数据库选型提供支撑。
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 2018.11.26
Copyright (c) Michel Cadot, 2016-2017. All rights reserved.
Usage: McOptions.exe [-h] [-f [-fr]] [-c [--disable option>[...]]] [-o] [-ro] [<logon>]
where <options> can be one or several of:
{ -c | --check } Checks now (requires SYSDBA privilege).
{ --disable <feature or option> }
Disable the checking of the given feature or option
(no effect if "-c" is not given)
{ -f | --features } Displays the paying used features in addition to the options and packs.
{ -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, display root only
(this option is ignored in versions 10g and 11g)
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 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 database.
- If the “-c” option is given, the program checks which ones are used in the current
instance. This option requires an account with SYSDBA privilege (there is no need
to specify “AS SYSDBA” in the parameter). - The other options requires an account with SELECT privilege on the V
D
A
T
A
B
A
S
E
,
V
DATABASE, V
DATABASE,VOPTION, V$VERSION, DBA_FEATURE_USAGE_STATISTICS, DBA_REGISTRY and
DBA_REGISTRY_SQLPATCH catalog views. - The program works for Oracle versions from 10gR1 to 18c.
- In 12c+ multitenant databases, if you are connected to the root container then the
program gives information for all the containers unless the option “-ro” is given. - There can be several “–disable” parameter.
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 informed when a new version is released.
Oracle12cR1数据库选项
1、默认输出示例
Here’s an example of execution with the default option on a 12cR1 database:
C:\>McOptions-64 michel/michel@mikcdb1
McOptions Utility by Michel Cadot: Version 2017.09.05
Copyright (c) Michel Cadot, 2016-2017. All rights reserved.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Database MIKC container MIKCDB1 instance mikc on myserver on 5-SEPT.-2017 11:34:06
Component Version Status Description
--------------- --------------- ----------- --------------------------------------------------
APEX 4.2.5.00.08 VALID Oracle Application Express
APS 12.1.0.2.0 VALID OLAP Analytic Workspace
CATALOG 12.1.0.2.0 VALID Oracle Database Catalog Views
CATJAVA 12.1.0.2.0 VALID Oracle Database Java Packages
CATPROC 12.1.0.2.0 VALID Oracle Database Packages and Types
CONTEXT 12.1.0.2.0 VALID Oracle Text
DV 12.1.0.2.0 VALID Oracle Database Vault
EXF 12.1.0.2.0 VALID Oracle Expression Filter
JAVAVM 12.1.0.2.0 VALID JServer JAVA Virtual Machine
OLS 12.1.0.2.0 VALID Oracle Label Security
ORDIM 12.1.0.2.0 VALID Oracle Multimedia
OWM 12.1.0.2.0 VALID Oracle Workspace Manager
RAC 12.1.0.2.0 OPTION OFF Oracle Real Application Clusters
RUL 12.1.0.2.0 VALID Oracle Rules Manager
SDO 12.1.0.2.0 VALID Spatial
XDB 12.1.0.2.0 VALID Oracle XML Database
XML 12.1.0.2.0 VALID Oracle XDK
XOQ 12.1.0.2.0 VALID Oracle OLAP API
Description Patch UID Version Flags Action Status Action time
------------------------------------------------------- ---------- ----------- ----- -------- ----------- -------------------
PATCH 22119791 19711199 12.1.0.2 N APPLY SUCCESS 01/08/2017 18:26:41
WINDOWS DB BUNDLE PATCH 12.1.0.2.160719(64bit):23530387 20414656 12.1.0.2 NB APPLY SUCCESS 01/08/2017 18:26:41
Option or Pack Usage Detected usages
------------------------------------- --------------------- ---------------
Diagnostics Pack Currently used 48
Entreprise Edition (no option/pack) Currently used 120
Multitenant Currently used 24
Tuning Pack Currently used 48 (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 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Then it displays a database specific banner:
Database MIKC container MIKCDB1 instance mikc on myserver on 5-SEPT.-2017 11:34:06
Then the installed components with their version and status (these information come from DBA_REGISTRY view):
Component Version Status Description
--------------- --------------- ----------- --------------------------------------------------
APEX 4.2.5.00.08 VALID Oracle Application Express
APS 12.1.0.2.0 VALID OLAP Analytic Workspace
CATALOG 12.1.0.2.0 VALID Oracle Database Catalog Views
CATJAVA 12.1.0.2.0 VALID Oracle Database Java Packages
CATPROC 12.1.0.2.0 VALID Oracle Database Packages and Types
CONTEXT 12.1.0.2.0 VALID Oracle Text
DV 12.1.0.2.0 VALID Oracle Database Vault
EXF 12.1.0.2.0 VALID Oracle Expression Filter
JAVAVM 12.1.0.2.0 VALID JServer JAVA Virtual Machine
OLS 12.1.0.2.0 VALID Oracle Label Security
ORDIM 12.1.0.2.0 VALID Oracle Multimedia
OWM 12.1.0.2.0 VALID Oracle Workspace Manager
RAC 12.1.0.2.0 OPTION OFF Oracle Real Application Clusters
RUL 12.1.0.2.0 VALID Oracle Rules Manager
SDO 12.1.0.2.0 VALID Spatial
XDB 12.1.0.2.0 VALID Oracle XML Database
XML 12.1.0.2.0 VALID Oracle XDK
XOQ 12.1.0.2.0 VALID Oracle OLAP API
Then, in versions 12c, the SQL or database patches (these information come from the DBA_REGISTRY_SQLPATCH, see the Oracle Reference book for an explaination of the columns):
Description Patch UID Version Flags Action Status Action time
------------------------------------------------------- ---------- ----------- ----- -------- ----------- -------------------
PATCH 22119791 19711199 12.1.0.2 N APPLY SUCCESS 01/08/2017 18:26:41
WINDOWS DB BUNDLE PATCH 12.1.0.2.160719(64bit):23530387 20414656 12.1.0.2 NB APPLY SUCCESS 01/08/2017 18:26:41
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.
2、检测是否使用企业版选项
You can see which features are used to justify these options using the “-f” option (“EE” means “Enterprise Edition”):
C:\>McOptions-64 -f michel/michel@mikcdb1
McOptions Utility by Michel Cadot: Version 2017.09.05
Copyright (c) Michel Cadot, 2016-2017. All rights reserved.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Database MIKC container MIKCDB1 instance mikc on myserver on 5-SEPT.-2017 11:35:42
Component Version Status Description
--------------- --------------- ----------- --------------------------------------------------
APEX 4.2.5.00.08 VALID Oracle Application Express
APS 12.1.0.2.0 VALID OLAP Analytic Workspace
CATALOG 12.1.0.2.0 VALID Oracle Database Catalog Views
CATJAVA 12.1.0.2.0 VALID Oracle Database Java Packages
CATPROC 12.1.0.2.0 VALID Oracle Database Packages and Types
CONTEXT 12.1.0.2.0 VALID Oracle Text
DV 12.1.0.2.0 VALID Oracle Database Vault
EXF 12.1.0.2.0 VALID Oracle Expression Filter
JAVAVM 12.1.0.2.0 VALID JServer JAVA Virtual Machine
OLS 12.1.0.2.0 VALID Oracle Label Security
ORDIM 12.1.0.2.0 VALID Oracle Multimedia
OWM 12.1.0.2.0 VALID Oracle Workspace Manager
RAC 12.1.0.2.0 OPTION OFF Oracle Real Application Clusters
RUL 12.1.0.2.0 VALID Oracle Rules Manager
SDO 12.1.0.2.0 VALID Spatial
XDB 12.1.0.2.0 VALID Oracle XML Database
XML 12.1.0.2.0 VALID Oracle XDK
XOQ 12.1.0.2.0 VALID Oracle OLAP API
Description Patch UID Version Flags Action Status Action time
------------------------------------------------------- ---------- ----------- ----- -------- ----------- -------------------
PATCH 22119791 19711199 12.1.0.2 N APPLY SUCCESS 01/08/2017 18:26:41
WINDOWS DB BUNDLE PATCH 12.1.0.2.160719(64bit):23530387 20414656 12.1.0.2 NB APPLY SUCCESS 01/08/2017 18:26:41
Option or Pack Usage Detected usages
------------------------------------- --------------------- ---------------
Diagnostics Pack Currently used 48
Entreprise Edition (no option/pack) Currently used 120
Multitenant Currently used 24
Tuning Pack Currently used 48 (requires Diagnostics Pack)
Feature EE Option or Pack Usage Comment
------------------------------------------------------ --- ------------------------- ------- --------------------------------
Adaptive Plans Yes 24 Currently used
Automatic Maintenance - SQL Tuning Advisor Yes Tuning Pack 24 Currently used
Deferred Segment Creation Yes 24 Currently used
Oracle Pluggable Databases Yes Multitenant 24 Currently used
Parallel SQL Query Execution Yes 24 Currently used
Partitioning (system) Yes 24 Currently used
Result Cache Yes 24 Currently used
SQL Plan Directive Yes Tuning Pack 24 Currently used
3、检测是否使用免费版选项
In addition, if you want to see which free features you used you can give the “–free” option:
C:\>McOptions-64 --free michel/michel@mikcdb1
McOptions Utility by Michel Cadot: Version 2017.09.05
Copyright (c) Michel Cadot, 2016-2017. All rights reserved.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Database MIKC container MIKCDB1 instance mikc on myserver on 5-SEPT.-2017 11:36:44
Component Version Status Description
--------------- --------------- ----------- --------------------------------------------------
APEX 4.2.5.00.08 VALID Oracle Application Express
APS 12.1.0.2.0 VALID OLAP Analytic Workspace
CATALOG 12.1.0.2.0 VALID Oracle Database Catalog Views
CATJAVA 12.1.0.2.0 VALID Oracle Database Java Packages
CATPROC 12.1.0.2.0 VALID Oracle Database Packages and Types
CONTEXT 12.1.0.2.0 VALID Oracle Text
DV 12.1.0.2.0 VALID Oracle Database Vault
EXF 12.1.0.2.0 VALID Oracle Expression Filter
JAVAVM 12.1.0.2.0 VALID JServer JAVA Virtual Machine
OLS 12.1.0.2.0 VALID Oracle Label Security
ORDIM 12.1.0.2.0 VALID Oracle Multimedia
OWM 12.1.0.2.0 VALID Oracle Workspace Manager
RAC 12.1.0.2.0 OPTION OFF Oracle Real Application Clusters
RUL 12.1.0.2.0 VALID Oracle Rules Manager
SDO 12.1.0.2.0 VALID Spatial
XDB 12.1.0.2.0 VALID Oracle XML Database
XML 12.1.0.2.0 VALID Oracle XDK
XOQ 12.1.0.2.0 VALID Oracle OLAP API
Description Patch UID Version Flags Action Status Action time
------------------------------------------------------- ---------- ----------- ----- -------- ----------- -------------------
PATCH 22119791 19711199 12.1.0.2 N APPLY SUCCESS 01/08/2017 18:26:41
WINDOWS DB BUNDLE PATCH 12.1.0.2.160719(64bit):23530387 20414656 12.1.0.2 NB APPLY SUCCESS 01/08/2017 18:26:41
Option or Pack Usage Detected usages
------------------------------------- --------------------- ---------------
Diagnostics Pack Currently used 48
Entreprise Edition (no option/pack) Currently used 120
Multitenant Currently used 24
Tuning Pack Currently used 48 (requires Diagnostics Pack)
EE Option or Pack Feature Usage Comment
--- ------------------------- ------------------------------------------------------ ------- --------------------------------
No Automatic Maintenance - Optimizer Statistics Gathering 24 Currently used
No Automatic Maintenance - Space Advisor 24 Currently used
No Automatic Reoptimization 24 Currently used
No Automatic SGA Tuning 24 Currently used
No Automatic SQL Execution Memory 24 Currently used
No Automatic Segment Space Management (system) 24 Currently used
No Automatic Segment Space Management (user) 24 Currently used
No Automatic Undo Management 24 Currently used
No Character Semantics 24 Currently used
No Character Set 24 Currently used
No Editioning Views 3 Currently used
No Editions 3 Currently used
No Job Scheduler 24 Currently used
No LOB 24 Currently used
No Locally Managed Tablespaces (system) 24 Currently used
No Locally Managed Tablespaces (user) 24 Currently used
No Logfile Multiplexing 24 Currently used
No MTTR Advisor 24 Currently used
No Oracle Java Virtual Machine (system) 24 Currently used
No RMAN - Disk Backup 2 Last: 07/08/2017
No Recovery Area 24 Currently used
No Recovery Manager (RMAN) 2 Last: 07/08/2017
No SecureFiles (system) 24 Currently used
No SecureFiles (user) 24 Currently used
No Server Parameter File 24 Currently used
No Services 24 Currently used
No Traditional Audit 24 Currently used
No Unified Audit 24 Currently used
Yes Adaptive Plans 24 Currently used
Yes Deferred Segment Creation 24 Currently used
Yes Parallel SQL Query Execution 24 Currently used
Yes Partitioning (system) 24 Currently used
Yes Result Cache 24 Currently used
Yes Multitenant Oracle Pluggable Databases 24 Currently used
Yes Tuning Pack Automatic Maintenance - SQL Tuning Advisor 24 Currently used
Yes Tuning Pack SQL Plan Directive 24 Currently used
The previous information come and are aggregated from the DBA_FEATURE_USAGE_STATISTICS view.
4、立即检查数据库选项使用情况
此选项需要使用sysdba权限执行
Now the program can immediately check the currently used options and features using the “-c” option:
C:\>McOptions-64 -c michel/michel@mikcdb1
McOptions Utility by Michel Cadot: Version 2017.09.05
Copyright (c) Michel Cadot, 2016-2017. All rights reserved.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Database MIKC container MIKCDB1 instance mikc on myserver on 5-SEPT.-2017 11:37:47
Component Version Status Description
--------------- --------------- ----------- --------------------------------------------------
APEX 4.2.5.00.08 VALID Oracle Application Express
APS 12.1.0.2.0 VALID OLAP Analytic Workspace
CATALOG 12.1.0.2.0 VALID Oracle Database Catalog Views
CATJAVA 12.1.0.2.0 VALID Oracle Database Java Packages
CATPROC 12.1.0.2.0 VALID Oracle Database Packages and Types
CONTEXT 12.1.0.2.0 VALID Oracle Text
DV 12.1.0.2.0 VALID Oracle Database Vault
EXF 12.1.0.2.0 VALID Oracle Expression Filter
JAVAVM 12.1.0.2.0 VALID JServer JAVA Virtual Machine
OLS 12.1.0.2.0 VALID Oracle Label Security
ORDIM 12.1.0.2.0 VALID Oracle Multimedia
OWM 12.1.0.2.0 VALID Oracle Workspace Manager
RAC 12.1.0.2.0 OPTION OFF Oracle Real Application Clusters
RUL 12.1.0.2.0 VALID Oracle Rules Manager
SDO 12.1.0.2.0 VALID Spatial
XDB 12.1.0.2.0 VALID Oracle XML Database
XML 12.1.0.2.0 VALID Oracle XDK
XOQ 12.1.0.2.0 VALID Oracle OLAP API
Description Patch UID Version Flags Action Status Action time
------------------------------------------------------- ---------- ----------- ----- -------- ----------- -------------------
PATCH 22119791 19711199 12.1.0.2 N APPLY SUCCESS 01/08/2017 18:26:41
WINDOWS DB BUNDLE PATCH 12.1.0.2.160719(64bit):23530387 20414656 12.1.0.2 NB APPLY SUCCESS 01/08/2017 18:26:41
Option or Pack Usage Detected usages
------------------------------------- --------------------- ---------------
Diagnostics Pack Currently used 48
Entreprise Edition (no option/pack) Currently used 120
Multitenant Currently used 24
Tuning Pack Currently used 48 (requires Diagnostics Pack)
Options currently used:
-----------------------
Entreprise Edition (no option/pack) -----> Adaptive Plans
Deferred Segment Creation
Parallel SQL Query Execution
Partitioning (system)
Result Cache
Multitenant -----------------------------> Oracle Pluggable Databases
Tuning Pack -----------------------------> Automatic Maintenance - SQL Tuning Advisor
SQL Plan Directive
The format is: —> .
“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 checks it the last time.
Note: the “-c” option requires an account with SYSDBA privilege (it is not needed to specify AS SYSDBA in the parameter).
5、查看已安装的数据库选项
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@mikcdb1
McOptions Utility by Michel Cadot: Version 2017.09.05
Copyright (c) Michel Cadot, 2016-2017. All rights reserved.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Advanced Analytics, Data Mining, OLAP, Partitioning and Real Application Testing options
Database MIKC container MIKCDB1 instance mikc on myserver on 5-SEPT.-2017 11:39:06
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
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
Component Version Status Description
--------------- --------------- ----------- --------------------------------------------------
APEX 4.2.5.00.08 VALID Oracle Application Express
APS 12.1.0.2.0 VALID OLAP Analytic Workspace
CATALOG 12.1.0.2.0 VALID Oracle Database Catalog Views
CATJAVA 12.1.0.2.0 VALID Oracle Database Java Packages
CATPROC 12.1.0.2.0 VALID Oracle Database Packages and Types
CONTEXT 12.1.0.2.0 VALID Oracle Text
DV 12.1.0.2.0 VALID Oracle Database Vault
EXF 12.1.0.2.0 VALID Oracle Expression Filter
JAVAVM 12.1.0.2.0 VALID JServer JAVA Virtual Machine
OLS 12.1.0.2.0 VALID Oracle Label Security
ORDIM 12.1.0.2.0 VALID Oracle Multimedia
OWM 12.1.0.2.0 VALID Oracle Workspace Manager
RAC 12.1.0.2.0 OPTION OFF Oracle Real Application Clusters
RUL 12.1.0.2.0 VALID Oracle Rules Manager
SDO 12.1.0.2.0 VALID Spatial
XDB 12.1.0.2.0 VALID Oracle XML Database
XML 12.1.0.2.0 VALID Oracle XDK
XOQ 12.1.0.2.0 VALID Oracle OLAP API
Description Patch UID Version Flags Action Status Action time
------------------------------------------------------- ---------- ----------- ----- -------- ----------- -------------------
PATCH 22119791 19711199 12.1.0.2 N APPLY SUCCESS 01/08/2017 18:26:41
WINDOWS DB BUNDLE PATCH 12.1.0.2.160719(64bit):23530387 20414656 12.1.0.2 NB APPLY SUCCESS 01/08/2017 18:26:41
Option or Pack Usage Detected usages
------------------------------------- --------------------- ---------------
Diagnostics Pack Currently used 48
Entreprise Edition (no option/pack) Currently used 120
Multitenant Currently used 24
Tuning Pack Currently used 48 (requires Diagnostics 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)
Last 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-23 (May 2018)
Oracle® Database Licensing Information User Manual 12c Release 2 (12.2) E85683-04 (August 2018)
Oracle® Database Database Licensing Information User Manual 18c E87202-07 (October 2018)
McOptions下载地址
链接:https://pan.baidu.com/s/100Wg-f_LYdDWC6EptdYfBQ
提取码:rmxq
32-bit:
MD5: 346eef786f3d9861fd8b14f896ad3fa9
SHA-1: 76f27fb2294186c9a29d8ea999a51a2b5a7bfdb7
64-bit:
MD5: d087847d49acf51629477b7d58886e41
SHA-1: 5634d968588dd4aca450f6bef7fa2c612695d330
原文链接
http://www.orafaq.com/forum/t/200328/
http://www.orafaq.com/wiki/Oracle_licensing