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
Unknown's avatar

Author: SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply

Discover more from SmartTechWays - Innovative Solutions for Smart Businesses

Subscribe now to keep reading and get access to the full archive.

Continue reading