Try this:
select
length(addr)*4 || '-bits'
from
v$process
where
ROWNUM =1;
On Mon, Nov 28, 2016 at 1:53 PM, Ls Cheng <exriscer@xxxxxxxxx> wrote:
Hi
Does anyone know if a database is currently in 64 or 32 bit?
IHAC migrated a few database a couple of weeks ago from Linux x86 to Linux
x86_64 and they unsure if utlirp.sql is run in all of them.
Anyone know how to check if the database is running in 64 bit mode? All I
have found is how to check binary bitness but not the database.
Thanks