Search This Blog

Wednesday, April 1, 2009

Database Created as 32bit Or 64bit Platform

We can check the Database Created as 32bit Or 64bit Platform through below sql query

SQL> select metadata from sys.kopm$ ;
METADATA

-----------------------------------------------------------0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405
0607080823472323081123081141B023008300B207D0030000000000000000000000000000000000
0000000000000000000000000000000000000000

If above Colored Character Is "B023" means 32bit

Or

If it is "B047" means 64bit.

Thanks.

2 comments:

Anonymous said...

Isn't it enought just to know on what OS your DB is running? If you are running on 32 bit platform then your DB is 32 and the same with 64...

Regards,
Ig

Nitin Chauhan said...

@anonymous ::
But on a 64bit OS we could install a 32 or a 64 bit database software.
hence it is important to know of what bit your DB sotware is.beacuse is we install a patch that patch should be of same bit as of the db software.else it would corrupt the DB software.