Check Exadata or Non-Exadata database in Oracle

Check database is Exadata or Non-Exadata database version:

SQL> SELECT decode(count(cell_path),0,'Non-Exadata','Exadata') "System" FROM v$cell;

System
-----------
Non-Exadata

If the count > 0 that means Exadata otherwise Non-Exadata

SQL> select count(distinct cell_path) from v$cell;

COUNT(DISTINCTCELL_PATH)
------------------------
                       0

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.