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

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Fri, 04 Oct 2002 05:23:27 -0800
Message-ID: <F001.004E0904.20021004052327@fatcity.com>

RAW is a datatype in oracle. Do a describe which gives the details of an object. For a table/view it tells you about the columns.

See the TYPE, which tells you about the datatype of the column. If it is RAW(4) it is 32-bit, if RAW(8) 64-bit.

SQL> desc v$session;

 Name                            Null?    Type
 ------------------------------- -------- ----
 SADDR                                    RAW(4)
 SID                                      NUMBER
 SERIAL#                                  NUMBER
 AUDSID                                   NUMBER
 PADDR                                    RAW(4)
 USER#                                    NUMBER
 USERNAME                                 VARCHAR2(30)
 COMMAND                                  NUMBER
 OWNERID                                  NUMBER
 TADDR                                    VARCHAR2(8)
 LOCKWAIT                                 VARCHAR2(8)
 STATUS                                   VARCHAR2(8)
 SERVER                                   VARCHAR2(9)
 SCHEMA#                                  NUMBER
 SCHEMANAME                               VARCHAR2(30)
 OSUSER                                   VARCHAR2(15)
 PROCESS                                  VARCHAR2(9)
 MACHINE                                  VARCHAR2(64)
 TERMINAL                                 VARCHAR2(16)
 PROGRAM                                  VARCHAR2(64)
 TYPE                                     VARCHAR2(10)
 SQL_ADDRESS                              RAW(4)
 SQL_HASH_VALUE                           NUMBER
 PREV_SQL_ADDR                            RAW(4)
 PREV_HASH_VALUE                          NUMBER
 MODULE                                   VARCHAR2(48)
 MODULE_HASH                              NUMBER
 ACTION                                   VARCHAR2(32)
 ACTION_HASH                              NUMBER
 CLIENT_INFO                              VARCHAR2(64)
 FIXED_TABLE_SEQUENCE                     NUMBER
 ROW_WAIT_OBJ#                            NUMBER
 ROW_WAIT_FILE#                           NUMBER
 ROW_WAIT_BLOCK#                          NUMBER
 ROW_WAIT_ROW#                            NUMBER
 LOGON_TIME                               DATE
 LAST_CALL_ET                             NUMBER
 PDML_ENABLED                             VARCHAR2(3)
 FAILOVER_TYPE                            VARCHAR2(13)
 FAILOVER_METHOD                          VARCHAR2(10)
 FAILED_OVER                              VARCHAR2(3)

Regards
Naveen

-----Original Message-----

mailto:VIVEK_SHARMA_at_infosys.com]
Sent: Friday, October 04, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L

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

--

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

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services -- 858-538-5051 <http://www.fatcity.com> 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).
--

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

Author:
INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services -- 858-538-5051 <http://www.fatcity.com> http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services

--

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

Author: Naveen Nahata
INET: naveen_nahata_at_mindtree.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 - 08:23:27 CDT

RE: Database is 32 or 64 Bit ? - Clarification