Hi Ram
I have used that query as well, I dont want to know if the database was
created in 32 bit, I want to know if it currently runs in 64 bit mode, that
is if UTLIRP.SQL has been run.
I will test all your sugegstion anyways in a few hours time and let you know
Thanks!
On Tue, Nov 29, 2016 at 12:37 PM, Ram Srinivasan <
srinivasanram2004@xxxxxxxxx> wrote:
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@xxxxxxxxx> 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@xxxxxxxxx> 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@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
--
Sincerely
Ram Srinivasan
--
Sincerely
Ram Srinivasan