McOptions-Oracle企业版功能使用情况检测工具

最新推荐文章于 2022-06-08 16:32:58 发布
最新推荐文章于 2022-06-08 16:32:58 发布
阅读量576 收藏
点赞数
分类专栏： oracle 文章标签： McOptions Oracle企业版功能检测
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/huryer/article/details/103753421
版权

概述

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

huryer
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
我的世界服务器文件翻译,【我的世界】options.txt文件翻译（无限夜视就是这个）...
weixin_32773101的博客
07-31 2825
该楼层疑似违规已被系统折叠隐藏此楼查看此楼以下是1.7.10的：invertYMouse:鼠标反转mouseSensitivity:鼠标灵敏度fov:视野gamma:亮度 (伽马值调到100就已经非常亮了，比夜视效果更佳)saturation:饱和度renderDistance:渲染距离guiScale:界面尺寸particles:粒子效果bobView:视角摇晃anaglyph3d:3D...
Oracle-RAC-高可用-性能-上线前测试报告
04-06
oracle RAC 在IBM小型机上的测试报告，双节点RAC的各项测试内容，单双节点的RAC性能测试内容，三节点RAC的RAC性能测试内容，RMAN测试，exp，imp测试，大批量呼叫数据测试，大批量查询测试，大事物测试，load balance测试，failover 测试，稳定性测试。单节点宕机切换测试，是RAC上线服务的测试模板的最佳参考。
oracle 如何检查企业在用,使用 Oracle 企业管理器第 2 版检查 Oracle 数据库
weixin_32098599的博客
04-05 301
使用 Oracle 企业管理器第 2 版检查 Oracle 数据库使用 Oracle 企业管理器 10g 第 2 版检查 Oracle 数据库目的本教程描述了如何使用 Oracle 企业管理器 10g 第 2 版监控性能和管理配置。所需时间大约半小时主题本教程包括下列主题：查看屏幕截图 将鼠标置于此图标上以加载和查看本教程的所有屏幕截图。(警告：此操作会同时加载所有屏幕截图，网速较慢时，响应时间可...
spring cloud bug
sweet6hero的专栏
11-29 304
$ curl localhost:8255/encrypt -d foobar-prd1                                                                                                                                                            
输入参数的设置--Option类的应用
云计算?
10-31 220
最近学习mahout的时候需要编译打包，然后在命令行运行程序，一般来说自己调试程序的话输入参数自己都是知道的，比较好设置比如你可以自己定义args[0] 是input,args[1]是output,但是如果其他人看你的程序的话，就很难搞懂哪个参数是对应的哪个。最近看到一个类Options和Option、CommandLine,这几个类可以提供一种参数输入错误的提示，而且比较好用，下面贴下一个使用d...
2a-Oracle企业管理器.pptx
07-09
Oracle企业管理器，简称OEM...总的来说，Oracle企业管理器是一个全面且强大的工具，它简化了Oracle环境的管理，通过其丰富的功能界面和联机帮助，DBA能够有效地监控和维护Oracle数据库系统，确保系统的稳定性和高效性。
PRMDUL PRM-DUL Oracle(数据库恢复工具) v4.1
10-17
PRM-DUL Oracle数据库恢复工具，一款专为Oracle数据救援而研发的企业级工具。可在多个操作平台（AIX/HPUX/SOLARIS/Linux/Windows）使用并支持对Oracle 9i/10g/11g/12c各版本数据库的数据救援工作。软
oracle提权工具-oracleShell.zip
05-04
Oracle数据库是全球广泛使用的数据库管理系统，它在企业级应用中占据着重要地位。然而，由于其复杂的权限系统，Oracle数据库也成为了黑客攻击的目标。"Oracle提权工具"是指那些可以帮助攻击者或者安全研究人员在...
基于java的开发源码-Oracle数据库工具 WARTS.zip
最新发布
01-08
基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发源码-Oracle数据库工具 WARTS.zip 基于java的开发...
Oracle数据库企业版-标准版功能对比[借鉴].pdf
10-11
Oracle数据库是全球广泛使用的大型企业级数据库管理系统，其企业版和标准版是两个主要的产品版本，各有不同的功能特性和适用场景。以下是对Oracle数据库11g标准版和企业版功能对比的详细说明： 1. 高可用性： - ...
快学Big Data--Linux（八）
知识的力量
09-02 6344
Linux总结   概述     Linux是一套免费使用和自由传播的类Unix操作系统（主要用在服务器上），接下来详细的介绍一下linux的一些知识。   Linux 目录结构说明 1-1）、目录树     1-2）、目录树介绍 / ：根目录，一般的只存放目录把存放文件 bin &amp; use/bin ：存放可执行的二进制文件 boot/：存放linux启动时用到...
win10安装Mysql8的两种方式(安装/卸载-图文教程)
zhh156282938的博客
06-08 4230
window安装mysql的两种方式以及配置文件说明
php 的开发工具
weixin_30591551的博客
11-27 86
通过上篇我们已经配置好了php的开发环境，我们就可以在这个模拟的环境下运行我们编写的php代码了。 在编写代码前，先安装一个自己喜欢的代码编辑器。 1.sublime text Sublime Text是一个代码编辑器也是HTML和散文先进的文本编辑器。漂亮的用户界面和非凡的功能，例如迷你地图，多选择，Python的插件，代码段，等等。完全可自定义键绑定，菜单和工具栏。Sublime Tex...
cmdlineparser java_cmdoption: CmdOption 是一个简单的注解驱动的命令行参数解析工具包，你所需要做的就是简单配置对象，每个字段和方法通过注解来定义...
weixin_39640262的博客
02-23 343
CmdOption - Command line parsing has never been easierOverviewCmdOption is a simple annotation-driven command line parser toolkit for Java 6 applications.Everything you need is (at least one) simple c...
查看Oracle数据库是企业版还是标准版
11-03 1353
1.查看v$version视图 select * from v$version Oracle Database 10g Enterprise Edition Release 10.2....
dreamweaver cs6
MADE_Y
08-31 2427
Dreamweaver_CS6安装与破解，手把手教程 听语音 | 浏览：28498 | 更新：2016-08-09 15:24 | 标签：DREAMWEAVER  1 2 3 4 5 6 7 分步阅读 Adobe Dreamweaver是一款非常好用的web前端设计工具，这里详细
oracle综合性能测试,性能测试关注的 Oracle 指标
weixin_39661881的博客
04-03 626
原标题：性能测试关注的 Oracle 指标作者：杨建旭，在自动化测试、性能测试方面有深入的研究，现任中国人民银行清算总中心性能测试团队负责人，高级技术经理。社区专栏：系统性能测试 http://www.talkwithtrend.com/home/space.php?p=blog&uid=898849数据库的性能优化是个非常复杂的事情，熟悉Oracle的专家能手更是数不胜数，所以写了数十篇...
01.26
sdau20171989的博客
01-27 130
1.用冒泡排序对数组元素按由小到大排序（数组作为函数参数） #include using namespace std; void bubble(int[],int); int main() { int array[10]={1,2,3,4,5,6,7,8,9,10}; bubble(array,10); for(int i=0;i<10;i++) cout
Oracle企业管理器详解：从OEM简介到功能界面
"Oracle企业管理器是Oracle10g提供的一款集成化的管理工具，主要分为数据库控制OEM、网格控制OEM和应用服务器控制OEM，用于全面管理和监控Oracle运行环境。它基于Java框架构建，采用Web应用方式，允许DBA远程通过Web...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值