Gary Robinson's oracleadvice.com has very good pointers on how to determine the wordsize on http://www.oracleadvice.com/Tips/32or64
select (case length(address)
when 16 then '64-bit Oracle'
when 8 then '32-bit Oracle'
when 32 then '128-bit Oracle'
end) Wordsize
from v$sql
where rownum <2
/
WORDSIZE
--------------
64-bit Oracle
1 comment:
Very easy way to find this info. Thank you very much!
Post a Comment