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-----
From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
Sent: Friday,
October 04, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L
Subject:
RE: Database is 32 or 64 Bit ? - Clarification
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
VIVEK_SHARMA
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).
--
Please see the official ORACLE-L
FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L
FAQ: http://www.orafaq.com
--
Author:
VIVEK_SHARMA
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).
- RE: Database is 32 or 64 Bit ? - Clarification VIVEK_SHARMA
- RE: Database is 32 or 64 Bit ? - Clarification Naveen Nahata
- RE: Database is 32 or 64 Bit ? - Clarification Inka Bezdziecka
- Re: Database is 32 or 64 Bit ? - Clarification Robyn Anderson Sands
