[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