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: