Couple of options:

In most versions of Unix:
> cd $ORACLE_HOME/bin
> file oracle
oracle: ELF 32-bit MSB executable ....

Select * from v$version - If it is 64 bit, I believe
it will show "64-bit" after the release ....

SVRMGR> select * from v$version
2> ;
BANNER

----------------------------------------------------------------
Oracle8 Enterprise Edition Release 8.0.6.3.0 -
Production




--- [Email Address Removed] wrote:
> How to determine RDBMS 32/64 bt using query?
> >
> > Hi members,
> >
> > How to determine RDBMS 32/64 bt using query? Some
> one had posted this earlier,post
> it again.
> >
> > TIA
>
>
>
______________________________________________________
> 123India.com - India's Premier Portal
> Get your Free Email Account at
> http://www.123india.com
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
Oracle LazyDBA home page