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;


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


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 /


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 ?


-----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


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

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
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).

Search Discussions

Discussion Posts


Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 4 | next ›
Discussion Overview
grouporacle-l @
postedOct 4, '02 at 12:08p
activeOct 4, '02 at 7:41p



site design / logo © 2022 Grokbase