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

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 )

Google photo

You are commenting using your Google 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