Version of Oracle

[cybtech]

Hi every body,

I have a little doubt :

How do i make sure of the version of Oracle 9i i'm running?

Well, i already know that it's a 9.2.0.4.0 but i need to know if it's a 32 or a 64 bits....

Any one have a clue?

 

[Dagon]

It should tell you when you go into SQL*Plus or you can do

"select * from v$version".

 

[cybtech]

I know that with a 8i when you go into SQL*plus it tells you only the oracle version when it's a 32 bits and that 64 bits is written just after when it's a 64bits version...

So it should be the same with 9i?

 

[stephenwales]

I don't have a 32 bit version to play with, but when I do a select * from v$version, I get the following (bolding mine):

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for HPUX: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production