Oracle Corporation periodically releases new version of oracle database software. As many as five numbers may be required to fully identify a release. From oracle you can check or find oracle database version.
How to See which database version I am using:
1)Select * from v$version;
2)SELECT * FROM PRODUCT_COMPONENT_VERSION;
PRODUCT VERSION STATUS
---------------------------------------- --------------- ---------------
NLSRTL 10.2.0.1.0 Production
Oracle Database 10g Enterprise Edition 10.2.0.1.0 Prod
PL/SQL 10.2.0.1.0 Production
TNS for Solaris: 10.2.0.1.0 Production
Release Number Format Description:
-------------------------------------
1)Major Database Release Number: (Here 10)
The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.
2)Database Maintenance Release Number:(Here 2)
The second digit represents a maintenance release level. Some new features may also be included.
3)Application Server Release Number:(Here 0)
The third digit reflects the release level of the Oracle Application Server.
4)Component-Specific Release Number: (Here 1)
The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.
5)Platform-Specific Release Number : (Here 0)
The fifth digit identifies a platform-specific release. Usually this is a patch set.
No comments:
Post a Comment