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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
