How Identifying 32 or 64 bit mode ?

[rrizzio]

How may I identify if an Oracle installation was made using 32 or 64 bits distribution ?
I'd like to identify it using only Oracle commands, not operating system commands.

Thanks in advance.

[rsuri]

I think this question was posted here a few weeks back...try connecting thru SQL/Plus; if it was 64-bit, it will display it in product version info; if it is 32-bit, it won't say anything about 32-bit or 64-bit.

- Rajeev

[pando]

select * from v$version will show you if Oracle is 64 bit or 32...

Now can anyone tell me how to check if SOlaris version running in my machine is 32 or 64 bits? :D

[rrizzio]

The v$version doesn't show 32 or 64 bit mode, at least when selecting its contents
from a 32 bit installation.

Is there another way besides SqlPlus ?

[marist89]

[QUOTE][i]Originally posted by pando [/i]
[B]Now can anyone tell me how to check if SOlaris version running in my machine is 32 or 64 bits? :D [/B][/QUOTE]
isainfo -v or isainfo -b