DETERMINE IF ORACLE DATABASE IS IN EXADATA MACHINE
To identify if an oracle database run on an exadata machine remotely, use these v$ views as a correlator
kish@exdbx<>select view_name from dba_views where view_name like '%CELL%';
VIEW_NAME
---------------
V_$CELL
V_$CELL_CONFIG
V_$CELL_OFL_THR
EAD_HISTORY
V_$CELL_REQUEST
_TOTALS
V_$CELL_STATE
V_$CELL_THREAD_
HISTORY
GV_$CELL
GV_$CELL_CONFIG
GV_$CELL_OFL_TH
READ_HISTORY
GV_$CELL_REQUES
T_TOTALS
GV_$CELL_STATE
GV_$CELL_THREAD
_HISTORY
There will be rows available under these views which means database run on exadata machine
If the output shows ‘no rows’ or ‘0 rows’ , then database is not in exadata
kish@exdbx<>select count(*) from v$cell_state;
COUNT(*)
--------------------------------------------------
533
Elapsed: 00:00:00.04
kish@exdbx<>select count(*) from v$cell;
COUNT(*)
--------------------------------------------------
1
Elapsed: 00:00:00.01
If it is not exadata database, then there will be zero rows in v$cell* views
SQL> select * from v$cell;
no rows selected