Thursday, January 14, 2016

How to check if database is exadata


select count(*) from (select distinct cell_name from gv$cell_state);
returns a number > 0, then the database runs on Exadata storage.


Non exadata:
-----------------

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

  COUNT(*)
----------
         0

SQL> select distinct cell_name from gv$cell_state;

no rows selected

No comments:

Post a Comment