HOME > > How to find Oracle Database Components version

How to find Oracle Database Components version

Anup - Wednesday, March 18, 2009
Oracle RDBMS Version
SELECT * FROM V$VERSION;

Version of OPATCH
$ perl $ORACLE_HOME/OPatch/opatch.pl version

Listener Version
$ lsnrctl version

Check Database 32-bit or 64-bit?

select length(addr)*4 '-bits' word_length from v$process where ROWNUM =1;

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me