Determine if 32-bit or 64-bit installed

From: Ed Stevens <nospam_at_noway.nohow>
Date: Tue, 11 Mar 2003 09:02:29 -0600
Message-ID: <hppr6v4cn48oiqgc46fhirheh95i2vvedh@4ax.com>

Platform: Sun Solaris, Oracle 8.1.7.0.0

We recently installed 8.1.7.0.0 on three Sun Solaris boxes. Now we need to apply the 8.1.7.4 patch/upgrade. Unfortunately, no one seems to know for sure if we are running the 32-bit or 64-bit version of Oracle (long story, involves application vendor!)

So my question is, is there a query or a log file that will tell me if I'm 32-bit or 64-bit? I thought v$version might, but that only yeilded

SQL> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production

SQL> Received on Tue Mar 11 2003 - 09:02:29 CST