Shulou(Shulou.com)05/31 Report--

Editor to share with you the Oracle-related components of the version of the sample analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Environmental preparation

Create a docker-style demo environment using a stripped-down version of Oracle

V$version view

The version information of each component of v$version can be confirmed by confirming the BANNER information of the Oracle view.

SQL > select * from v$version BANNER----Oracle Database 11g Express Edition Release 11.2.0.2.0-64bit ProductionPL/SQL Release 11.2.0.2.0-ProductionCORE 11.2.0.2 .0 ProductionTNS for Linux: Version 11.2.0.2.0-ProductionNLSRTL Version 11.2.0.2.0-ProductionSQL >

Oracle version information description

With regard to the XE version of Oracle used, there is a version number, 11.2.0.2.0, which you can see with. For the purpose of division, it is divided into five parts, and the significance of each part is as follows:

Product_component_version

In addition, the information in v$version can also be obtained from product_component_version

SQL > desc product_component_version Name Null? Type PRODUCT VARCHAR2 (320) VERSION VARCHAR2 (320) STATUS VARCHAR2 (320) SQL >

Because each column of product_component_version is too long, you need to set column before you confirm it, otherwise the general screen line will not be displayed. You can get similar version information by using select.

SQL > column product format a20SQL > column version format a20SQL > column status format a20SQL > select * from product_component_version PRODUCT VERSION STATUS- NLSRTL 11.2.0.2.0 ProductionOracle Database 11g 11.2.0.2.0 64bit ProductionExpress EditionPL/SQL 11.2.0.2.0 ProductionTNS for Linux: 11.2.0.2.0 ProductionSQL >

V$intance

Of course, if you have the sample information, you can also confirm the version information by confirming the Version field in the v$intance view.

SQL > desc v$instance Name Null? Type-INSTANCE_NUMBER NUMBER INSTANCE_NAME VARCHAR2 (16) HOST_NAME VARCHAR2 (64) VERSION VARCHAR2 (17) STARTUP_TIME DATE STATUS VARCHAR2 (12) PARALLEL VARCHAR2 (3) THREAD# NUMBER ARCHIVER VARCHAR2 (7) LOG_SWITCH_WAIT VARCHAR2 (15) LOGINS VARCHAR2 (10) SHUTDOWN_PENDING VARCHAR2 (3) DATABASE_STATUS VARCHAR2 (17) INSTANCE_ROLE VARCHAR2 (18) ACTIVE_STATE VARCHAR2 (9) BLOCKED VARCHAR2 (3) EDITION VARCHAR2 (7) SQL > select version from v$instance VERSION-11.2.0.2.0SQL >

Sqlplus-v

Confirm that the version information of the sqlplus client can be done through sqlplus-v, or the execution result of the sqlplus can also be seen.

Oracle@e871d42341c0:~$ sqlplus-vSQL*Plus: Release 11.2.0.2.0 Productionoracle@e871d42341c0:~$ and above are all the contents of this article entitled "sample Analysis of Oracle related component version Information". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.