Perhaps it is even simpler to describe V$session
The first column SADDR is raw(8) on 64 bit and is raw(4) on 32 bit databases
John
-Original Message-
Sent: 23 September 2003 22:25
To: Multiple recipients of list ORACLE-L
Oracle DBA wrote:
Also how to check whether my DB is 32 or 64
Hi List
How to check whether i am running 32 or 64 bit Sun
Solaris?
Also how to check whether my DB is 32 or 64 bit
TIA
Sami
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official
To find out about oracle go to $ORACLE_HOME/bin
Type
File oracle
Hope this helps.
-Original Message-
Sent: Tuesday, September 23, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Hi List
How to check whether i am running 32 or 64 bit Sun
Solaris?
Also how to check whether my DB
This link may help.
http://www.oracleadvice.com/Tips/32or64bit.htm
-Original Message-
Sent: Tuesday, September 23, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Hi List
How to check whether i am running 32 or 64 bit Sun
Solaris?
Also how to check whether my DB is 32 or 64 bit
How to check whether i am running 32 or 64
bit Sun Solaris?
$ isainfo -kv
64-bit sparcv9 kernel modules
Also how to check whether my DB is 32 or
64 bit
$ file $ORACLE_HOME/bin/oracle
/oracle/u01/8.1.7/bin/oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically
linked, not stripped
Oracle DBA wrote:
Also how to check whether my DB is 32 or 64 bit
SQL SELECT dbms_utility.port_string FROM dual;
PORT_STRING
SVR4-be-64bit-8.1.0
SQL SELECT paddr FROM v$session WHERE rownum 2;
PADDR
00038A57CA28
SQL connect