Re: how to check 32 bit -> 64 bit migration

Hi Ram

I already tested that, once a database is migrated to 64 bit and utlirp.sql is NOT executed that query returns 64 bit too!

Thanks

On Tue, Nov 29, 2016 at 1:40 AM, Ram Srinivasan <srinivasanram2004_at_gmail.com
> wrote:

> 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_at_gmail.com> 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
>>
>>
>>
>
>
> --
> Sincerely
> Ram Srinivasan
>

--
http://www.freelists.org/webpage/oracle-l