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
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Inka Bezdziecka
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).
