Oracle-L: Re: Database is 32 or 64 Bit ?

From: Robyn Anderson Sands <Robyn_at_iTeamTech.com>
Date: Fri, 04 Oct 2002 11:41:44 -0800
Message-ID: <F001.004E12BC.20021004114144@fatcity.com>

Query the v$sql table. If the 'address' field contains 8 hex characters, it's 32 bit. If there are 16 characters, it's 64 bit.

select address from v$sql
where rownum < 2;

Robyn

Inka Bezdziecka wrote:
> you need to 'describe' v$session, not to 'select' from it
>
> SQL> desc v$session
>
> -----Original Message-----
> Sent: Friday, October 04, 2002 8:08 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
>
> Qs What do you mean by raw(4) / raw(8) ?
> Does it mean Length of the Field Data Value ?
>

>>From my Database :-

>
> SQL> select saddr from v$session where rownum < 2
> 2 /
>
> SADDR
> --------
> 313941C0
>
>
> CASE - Assuming on receiving a Database from a 3rd party
> 1) My Existing Installed ORACLE_HOME software is 64 - Bit
> 2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of )
>
> Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Still
> show raw(4) values ?
>
> Thanks
>
> -----Original Message-----
> Sent: Friday, October 04, 2002 1:03 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I posted the note below a few weeks ago, hope it helps
>
> John
>
> Listers,
> Here is a little summary of commands to identify the bit version of an o/s
> and 2 methods of identifying whether a database is a 32 bit or 64 bit
> installation
>
> Operating System
>
> Compaq Tru 64 - will be 64 bit
>
> HP-UX /usr/sbin/swlist | grep -E '32|64' returns
> HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime
> Environment if 64 bit
> Sun isalist -v
> If the return contains the phrase 'sparcv9' then it is a 64 bit o/s
> Oracle Version
> To check Oracle version - 2 methods
> do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64
> executable
> Within sqlplus desc v$session and look for the definition of saddr (if
> raw(4) then 32 bit else if raw(8) 64 bit)
>
>
>
> -----Original Message-----
> Sent: 04 October 2002 07:53
> To: Multiple recipients of list ORACLE-L
>
>
>
> Given a Database . It is 32 Bit or 64 Bit , how can it be found ?
>
> Assuming Cold Backup of Database Sent from Elsewhere
>
>

-- 
Robyn Anderson Sands
iTeam Technologies, Inc.
Office: 404.816.6920
Mobile: 404.234.4873

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robyn Anderson Sands
  INET: Robyn_at_iTeamTech.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Fri Oct 04 2002 - 14:41:44 CDT

Re: Database is 32 or 64 Bit ? - Clarification