Re: How to check whether the oracle is 32 bit or 64 ??

From: Eve Hoellwarth <niemand_at_nicht_da.de>
Date: Wed, 10 Jul 2002 13:38:27 +0200
Message-ID: <cn6oiu0bn71qdrajh62rm3rrfv4sr2o3nq@4ax.com>

mailmizak_at_yahoo.com (mizak) wrote:

>Thanks in advance ..
>
>How to check whether the oracle is 32 bit or 64 ??
>for Unix or specifically for solaris operating system for 8.1.7 or 9i
>oracle software ...

select * from v$version;
will give a string '64bit' in the banner if your installed binaries are 64bit. There's no string for 32bit binaries

select * from v$type_size;
will give you two entries to determine the filesize of the instance:

COMPONEN TYPE     DESCRIPTION                      TYPE_SIZE  
-------- -------- -------------------------------- ---------- 
S        SIZE_T   SIZE_T                                    8 
S        PTR_T    PTR_T                                     8

type_size 8 stands for 64bit, type_size 4 stands for 32bit wordsize of the instance

kind regards
Eve Received on Wed Jul 10 2002 - 06:38:27 CDT