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

Cheng:
  Try this. I used this query long time ago:

/* To identify whether a database was created as 32-bit or 64-bit,

    execute the following SQL statement: */

select
  case
    when INSTR(metadata,'B047') > 1 then 'The Database is 64 Bit.'     when INSTR(metadata,'B023') > 1 then 'The Database is 32 Bit.'     end as Result
from sys.kopm$ ;

/*
If the output references the string 'B023' , then it indicates that the database was created as 32-bit.

If the output references the string 'B047' then it indicates that the database was created as 64-bit.
*/

On Tue, Nov 29, 2016 at 3:56 AM, Ls Cheng <exriscer_at_gmail.com> wrote:

> 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
>>
>
>

-- 
Sincerely
Ram Srinivasan

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