How to check Oracle Exadata Model

Sometimes you would be curious to know while working on Exadata database that what Exadata model your database is using??

Here is simple thing you can check being logged into any of the compute node of Exadata cluster(of course you can login to compute node since you support the databases running on it or except DBaaS instances for Oracle private cloud, depends on the project level work and roles you are involved in and it's access level)

Login to the exadata compute node 1 and navigate to the following directory.

$cd /opt/oracle.SupportTools/onecommand

Then

$cat databasemachine.xml | grep MACHINE

and you will get the below output detailing about the exadata model you are just playing with.

/opt/oracle.SupportTools/onecommand
dbm01rac01[TESTDB] cat databasemachine.xml | grep MACHINE

<MACHINETYPE>36</MACHINETYPE>
<MACHINETYPE>X3-2 Half Rack HC 3TB</MACHINETYPE>
<MACHINEUSIZE>42</MACHINEUSIZE>




In above output you would see that our current Exadata Database Machine Model is X3-2 Half Rack High Capacity with 3TB size of each HDD.