We can check the Database Created as 32bit Or 64bit Platform through below sql query
SQL> select metadata from sys.kopm$ ;
METADATA-----------------------------------------------------------0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405
0607080823472323081123081141B023008300B207D0030000000000000000000000000000000000
0000000000000000000000000000000000000000If above Colored Character Is "B023" means 32bit
Or
If it is "B047" means 64bit.
Thanks.
Wednesday, April 1, 2009
Database Created as 32bit Or 64bit Platform
Subscribe to:
Post Comments (Atom)
2 comments:
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
@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.
Post a Comment