Mohamed Azar Shaj

Oracle DBA, azarmohds@gmail.com, Riyadh Kingdom Of Saudi Arabia

Oracle Certification ** Oracle-Base ** Export and Import ** Charater set migration

About Me

My photo
Database Administrator and like to read about hackers and them activities...and completed Oracle 10g Certified associate. Active member of Oracle Forum

Oracle Database created as 32bit or 64bit

7:33 PM / Posted by Azar Mohamed Shaj /

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


SQL> select metadata from sys.kopm$ ;METADATA
-----------------------------------------------------------0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A050505050504050607080823472323081123081141B023008300B207D00300000000000000000000000000000000000000000000000000000000000000000000000000


If above Colored Character Is "B023" means 32bit


Or
If it is "B047" means 64bit.

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)