32-bit or 16-bit??

[Trina]

Hi Everyone,
Is there a way that you can query to see if your dabasase is 16-bit or 32-bit level?
I know that certain versions allow you to see it when you start svrmgrl.

[sreddy]

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

[Trina]

I tried to query v$version in version 7.3.4 and it does
not show the bit level.

[sambavan]

Go to $ORACLE_HOME/bin if it was on a Unix OS then you can use the command file to find out about it

$ file oracle

This would reveal the type of oracle version.

Sam