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

Search Discussions

Discussion Posts

Previous

Related Discussions

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

People

Translate

site design / logo © 2022 Grokbase