Hiya Buddies, Topic: How to check version of the database
Hope you all are doing well…
As we know that we all should know that How to check the database
version and on which database version we are working which is very important.
Even it will be asked in our interviews also that on which database you working and what are their features, how much is the database size.
So, below is the command and details, the way we can check the
database version and database details with the numeric forms.
But we are not sure the meaning of the version details as like
what is the meaning of the 11.2.0.4.0 which would like to share here.
So, we would like to share the
knowledge which is just for knowledge purpose which may helpful for you all
here…
Below are the commands which helps or
used for checking the Database version.
How to check version of
the database:
SQL> SELECT * FROM V$VERSION;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Solaris: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> SELECT version
FROM V$INSTANCE;
VERSION
-----------------
11.2.0.4.0
SQL>
How to check the Database Size:
select sum(bytes)/1024/1024 size_in_mb from dba_data_files;
select sum(bytes)/1024/1024 size_in_mb from dba_segments;
Here are the meanings which may help more
to understand which very few people clear about it like as:
11- Major database release number,
2 - Database maintenance release number,
0 - Application server release number,
4 - Component specific release number,
0 - Platform specific release number.
Some more useful links:
Regards,
TechOrNontech Team
No comments:
Post a Comment