CNDBA社区
1.Major Database Release Number
第一个数字位，它代表的是一个新版本软件，也标志着一些新的功能。如11g，10g。
2.Database Maintenance Release Number
第二个数字位，代表一个maintenance release 级别，也可能包含一些新的特性。
3.Fusion Middleware Release Number
第三个数字位，反应Oracle 中间件（Oracle Fusion Middleware）的版本号。
4.Component-Specific Release Number
第四个数字位，主要是针对组件的发布级别。不同的组件具有不同的号码。 比如Oracle 的patch包。
5.Platform-Specific Release Number
第五个数字位，这个数字位标识一个平台的版本。 通常表示patch 号。
6.查看版本
sys@testDB 10:42:45> select * from v$version;
BANNER BANNER_FULL BANNER_LEGACY CON_ID
-------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 0
Version 19.13.0.0.0
Elapsed: 00:00:00.00
sys@TESTDB 10:42:52> SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION_FULL
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS
----------
Oracle Database 19c Enterprise Edition
19.0.0.0.0
19.13.0.0.0
Production
Elapsed: 00:00:00.00
sys@TESTDB 10:43:06> select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
Oracle Database Catalog Views 19.0.0.0.0 VALID
Oracle Database Packages and Types 19.0.0.0.0 VALID
Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF
JServer JAVA Virtual Machine 19.0.0.0.0 VALID
Oracle XDK 19.0.0.0.0 VALID
Oracle Database Java Packages 19.0.0.0.0 VALID
OLAP Analytic Workspace 19.0.0.0.0 VALID
Oracle XML Database 19.0.0.0.0 VALID
Oracle Workspace Manager 19.0.0.0.0 VALID
Oracle Text 19.0.0.0.0 VALID
Oracle Multimedia 19.0.0.0.0 VALID
Spatial 19.0.0.0.0 VALID
Oracle OLAP API 19.0.0.0.0 VALID
Oracle Label Security 19.0.0.0.0 VALID
Oracle Database Vault 19.0.0.0.0 VALID
15 rows selected.
Elapsed: 00:00:00.02
sys@TESTDB 10:43:20> select * from v$option;
PARAMETER VALUE CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----------
Partitioning TRUE 0
Objects TRUE 0
Real Application Clusters FALSE 0
Advanced replication TRUE 0
Bit-mapped indexes TRUE 0
Connection multiplexing TRUE 0
Connection pooling TRUE 0
Database queuing TRUE 0
Incremental backup and recovery TRUE 0
Instead-of triggers TRUE 0
Parallel backup and recovery TRUE 0
Parallel execution TRUE 0
Parallel load TRUE 0
Point-in-time tablespace recovery TRUE 0
Fine-grained access control TRUE 0
Proxy authentication/authorization TRUE 0
Change Data Capture TRUE 0
Plan Stability TRUE 0
Online Index Build TRUE 0
Coalesce Index TRUE 0
Managed Standby TRUE 0
Materialized view rewrite TRUE 0
Database resource manager TRUE 0
Spatial TRUE 0
Automatic Storage Management FALSE 0
Export transportable tablespaces TRUE 0
Transparent Application Failover TRUE 0
Fast-Start Fault Recovery TRUE 0
Sample Scan TRUE 0
Duplexed backups TRUE 0
Java TRUE 0
OLAP Window Functions TRUE 0
Block Media Recovery TRUE 0
Fine-grained Auditing TRUE 0
Application Role TRUE 0
Enterprise User Security TRUE 0
Oracle Data Guard TRUE 0
Oracle Label Security FALSE 0
OLAP TRUE 0
Basic Compression TRUE 0
Join index TRUE 0
Trial Recovery TRUE 0
Advanced Analytics TRUE 0
Online Redefinition TRUE 0
Streams Capture TRUE 0
File Mapping TRUE 0
Block Change Tracking TRUE 0
Flashback Table TRUE 0
Flashback Database TRUE 0
Transparent Data Encryption TRUE 0
Backup Encryption TRUE 0
Unused Block Compression TRUE 0
Oracle Database Vault FALSE 0
Result Cache TRUE 0
SQL Plan Management TRUE 0
SecureFiles Encryption TRUE 0
Real Application Testing TRUE 0
Flashback Data Archive TRUE 0
DICOM TRUE 0
Active Data Guard TRUE 0
Server Flash Cache TRUE 0
Advanced Compression TRUE 0
XStream TRUE 0
Deferred Segment Creation TRUE 0
Unified Auditing FALSE 0
Management Database FALSE 0
I/O Server FALSE 0
ASM Proxy Instance FALSE 0
Exadata Discovery TRUE 0
Data Mining TRUE 0
Global Data Services TRUE 0
Adaptive Execution Plans TRUE 0
Table Clustering TRUE 0
Zone Maps TRUE 0
Real Application Security TRUE 0
Privilege Analysis TRUE 0
Data Redaction TRUE 0
Cross Transportable Backups TRUE 0
Cache Fusion Lock Accelerator TRUE 0
Snapshot time recovery TRUE 0
Heat Map TRUE 0
Automatic Data Optimization TRUE 0
Transparent Sensitive Data Protection TRUE 0
In-Memory Column Store TRUE 0
Advanced Index Compression TRUE 0
In-Memory Aggregation TRUE 0
Centrally Managed User TRUE 0
87 rows selected.
Elapsed: 00:00:00.00
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle
