RE: Oracle 32bit / 64bit

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Tue, 17 Jul 2001 13:00:13 -0700
Message-ID: <F001.0034CB50.20010717131046@fatcity.com>

Mitchell,

We have both 32 bit and 64 bit Oracle 817 running on Solaris 7.

The easiest way is --- When you log onto SQL, then you would get a message similar to following:

Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64 bit production

Now, if you are running 32 bit version, you get the following message

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

Please observe that the above message is not telling whether it is 32 or 64. But for 64 bit, the message specifically tells you.

Thanks,

Rao

-----Original Message-----
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L

Dear DBAs

How can I know my Oracle running on 32 or 64bit ? I am considering change configuration of SGA. Currently OS is updated to 8g memory on aix 4.3.3.
The limit is 2gb for 32bit ?

I only know if you switch from 32bit to 64bit or vice-a-versa, then you also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and alters certain dictionary tables.

Mitchell

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rao, Maheswara
  INET: Maheswara.Rao_at_Sungardp3.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 17 2001 - 15:00:13 CDT