How to know if your Database is running on Exadata Machine?

Today one of my friend asked me how can we identify if our Oracle database we are connected is running on Oracle Exadata Database Machine or not? It was pretty good question, right?

Well, suppose, you had been working with non-Exadata machines and you joined a new company and there are various Database systems in your IT Infrastructure, some of the databases are hosted on Exadata Database Machine and some of them are running on non-Exadata Servers.

Mostly, you won't have the access to Cell Nodes of Exadata Storage server so you may find it difficult to identify the answer of your questions.

Now, knowing that your team supports Exadata, you would now be too excited to know about it, right?

Here you go :-)

Below is the simple SQL query which would tell if your Oracle database running on Exadata Machine or not.

SQL> select * from (select count( distinct cell_name) from v$cell_state);

COUNT(CELL_NAME)
----------------
           0



OR

 select case when count(cell_name) > 0 then 'EXADATA'
 else 'NOT EXADATA' END "IsExadata"
 from v$cell_state; 




If above query returns zero(0) rows then your Oracle database you are connected is not running on Exadata Database Machine and if it returns values (minimum would be 3 rows as Exadata Database Machine has minimum 3 storage cell nodes) then your database you are connected is running on Exadata Database machine.