[20200228]如何判断服务器是exadata.txt

[20200228]如何判断服务器是exadata.txt --//别人问的问题，实际上很简单找一个小表。 select * from xxxx ; --//检查执行计划看看是否TABLE ACCESS STORAGE FULL。 Plan hash value: 3123998556 -------------------------------------------------------------------------------------------------------------- | Id  | Operation                 | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |  OMem |  1Mem | Used-Mem | -------------------------------------------------------------------------------------------------------------- |   0 | SELECT STATEMENT          |      |        |       |     3 (100)|          |       |       |          | |   1 |  TABLE ACCESS STORAGE FULL| XXXX |      4 |    80 |     3   (0)| 00:00:01 |  1025K|  1025K|          | -------------------------------------------------------------------------------------------------------------- --//如果是TABLE ACCESS FULL基本可以确定不是。 Plan hash value: 3383998547 --------------------------------------------------------------------------- | Id  | Operation         | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time   | --------------------------------------------------------------------------- |   0 | SELECT STATEMENT  |      |        |       |     3 (100)|          | |   1 |  TABLE ACCESS FULL| DEPT |      4 |    80 |     3   (0)| 00:00:01 | --------------------------------------------------------------------------- Query Block Name / Object Alias (identified by operation id): -------------------------------------------------------------    1 - SEL$1 / DEPT@SEL$1 --//还可以查询相关视图： SCOTT@book> @ view cell OWNER  VIEW_NAME                      C30 ------ ------------------------------ ------------------------------ SYS    V_$CELL                        V$CELL SYS    V_$CELL_CONFIG                 V$CELL_CONFIG SYS    V_$CELL_OFL_THREAD_HISTORY     V$CELL_OFL_THREAD_HISTORY SYS    V_$CELL_REQUEST_TOTALS         V$CELL_REQUEST_TOTALS SYS    V_$CELL_STATE                  V$CELL_STATE SYS    V_$CELL_THREAD_HISTORY         V$CELL_THREAD_HISTORY SYS    GV_$CELL                       GV$CELL SYS    GV_$CELL_CONFIG                GV$CELL_CONFIG SYS    GV_$CELL_OFL_THREAD_HISTORY    GV$CELL_OFL_THREAD_HISTORY SYS    GV_$CELL_REQUEST_TOTALS        GV$CELL_REQUEST_TOTALS SYS    GV_$CELL_STATE                 GV$CELL_STATE SYS    GV_$CELL_THREAD_HISTORY        GV$CELL_THREAD_HISTORY SYSMAN MGMT_EMX_CELL_CD_CONFIG_VIEW   MGMT_EMX_CELL_CD_CONFIG_VIEW SYSMAN MGMT_EMX_CELL_C_CONFIG_VIEW    MGMT_EMX_CELL_C_CONFIG_VIEW SYSMAN MGMT_EMX_CELL_GD_CONFIG_VIEW   MGMT_EMX_CELL_GD_CONFIG_VIEW SYSMAN MGMT_EMX_CELL_IORM_CONFIG_VIEW MGMT_EMX_CELL_IORM_CONFIG_VIEW SYSMAN MGMT_EMX_CELL_L_CONFIG_VIEW    MGMT_EMX_CELL_L_CONFIG_VIEW SYSMAN MGMT_EMX_CELL_PD_CONFIG_VIEW   MGMT_EMX_CELL_PD_CONFIG_VIEW 18 rows selected. SCOTT@book> select * from v$cell ; no rows selected --//如果是exadata，一定有输出。我不知道ODA的情况，估计也应该一样。 > select count(*) from v$cell ;   COUNT(*) ----------          3