DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, April 26, 2015

   Query to check wordsize ( 32 bit or 64 bit ) of Oracle Database



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;

No comments: