oracle統計資訊--直方圖的收集：
oracle還可以通直方圖來收集統計資訊，這個例子值收集一個表的直方圖統計資訊：
以下是實驗過程：
---建立測試表：
SQL> create table t as select * from dba_objects;
Table created.
---呼叫系統的 dbms_stats包收集統計資訊：
SQL> exec dbms_stats.gather_table_stats(user,'T');
PL/SQL procedure successfully completed.
---此時資料庫為表上的所有欄位收集了預設的統計資訊，每個列兩個Bucket：
col column_name for a30
col owner for a10
col table_name for a10
col ENDPOINT_ACTUAL_VALUE for a10
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ------------------------------ --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJECT_ID 1 89403
SYSTEM T DATA_OBJECT_ID 0 0
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_TIME 1 2457674.88
SYSTEM T LAST_DDL_TIME 0 2452549.53
SYSTEM T NAMESPACE 0 1
SYSTEM T NAMESPACE 1 64
SYSTEM T OBJECT_ID 1 89403
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ------------------------------ --------------- -------------- ----------
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAME 0 2.4504E+35
SYSTEM T OBJECT_NAME 1 6.2963E+35
SYSTEM T OBJECT_TYPE 0 3.4943E+35
SYSTEM T OBJECT_TYPE 1 4.5849E+35
SYSTEM T OWNER 0 3.3913E+35
SYSTEM T OWNER 1 4.5831E+35
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T SECONDARY 0 4.0500E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T STATUS 0 4.4786E+35
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ------------------------------ --------------- -------------- ----------
SYSTEM T SUBOBJECT_NAME 1 4.5340E+35
SYSTEM T SUBOBJECT_NAME 0 1.8867E+35
SYSTEM T TEMPORARY 1 4.6211E+35
SYSTEM T TEMPORARY 0 4.0500E+35
SYSTEM T TIMESTAMP 0 2.5558E+35
SYSTEM T TIMESTAMP 1 2.6059E+35
28 rows selected.
#共28條記錄。
---同時，列的低值、高值等資訊會被收集記錄在dba_tab_col_statistics中：
SQL> set linesize 150;
SQL> select table_name,column_name,num_distinct,low_value,high_value,DENSITY
from dba_tab_col_statistics where owner='SYSTEM' and table_name='T';
TABLE_NAME COLUMN_NAM NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY
---------- ---------- ------------ ------------------------------ ------------------------------ ----------
T OWNER 32 415045585F303330323030 584442 .03125
T OBJECT_NAM 52336 2F31303030333233645F44656C6567 794362437253756253616D706C696E .000019107
E 617465496E766F636174696F6E4861 67547970653232395F54
T SUBOBJECT_ 148 2456534E5F31 575248245F5741495453545F323338 .006756757
NAME 3739363238335F30
T OBJECT_ID 87106 C103 C3095F04 .00001148
T DATA_OBJEC 9218 80 C3095F04 .000108483
T_ID
TABLE_NAME COLUMN_NAM NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY
---------- ---------- ------------ ------------------------------ ------------------------------ ----------
T OBJECT_TYP 45 434C5553544552 584D4C20534348454D41 .022222222
E
T CREATED 949 787108180C2624 78740A0C160334 .001053741
T LAST_DDL_T 1057 78660A010D2A32 78740A0C160334 .000946074
IME
T TIMESTAMP 1094 313939302D30382D32363A31313A32 323031362D31302D31323A32313A30 .000914077
353A3030 323A3531
T STATUS 1 56414C4944 56414C4944 1
TABLE_NAME COLUMN_NAM NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY
---------- ---------- ------------ ------------------------------ ------------------------------ ----------
T TEMPORARY 2 4E 59 .5
T GENERATED 2 4E 59 .5
T SECONDARY 2 4E 59 .5
T NAMESPACE 21 C102 C141 .047619048
T EDITION_NA 0 0
ME
15 rows selected.
---收集所有欄位的直方圖統計資訊：
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt => 'for all columns size 1');
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for columns owner size 1');
PL/SQL procedure successfully completed.
---刪除以上的兩個引數之後：
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJEC 1 89403
T_ID
SYSTEM T DATA_OBJEC 0 0
T_ID
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_T 1 2457674.88
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
IME
SYSTEM T LAST_DDL_T 0 2452549.53
IME
SYSTEM T NAMESPACE 0 1
SYSTEM T NAMESPACE 1 64
SYSTEM T OBJECT_ID 1 89403
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAM 0 2.4504E+35
E
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OBJECT_NAM 1 6.2963E+35
E
SYSTEM T OBJECT_TYP 0 3.4943E+35
E
SYSTEM T OBJECT_TYP 1 4.5849E+35
E
SYSTEM T OWNER 0 3.3913E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OWNER 1 4.5831E+35
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T SECONDARY 0 4.0500E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T STATUS 0 4.4786E+35
SYSTEM T SUBOBJECT_ 1 4.5340E+35
NAME
#共28條記錄。
--- 透過dbms_stats.delete_column_stats包刪除owner欄位：
SQL> exec dbms_stats.delete_column_stats(user,'T','OWNER');
PL/SQL procedure successfully completed.
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJEC 1 89403
T_ID
SYSTEM T DATA_OBJEC 0 0
T_ID
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_T 1 2457674.88
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
IME
SYSTEM T LAST_DDL_T 0 2452549.53
IME
SYSTEM T NAMESPACE 1 64
SYSTEM T NAMESPACE 0 1
SYSTEM T OBJECT_ID 1 89403
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAM 0 2.4504E+35
E
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OBJECT_NAM 1 6.2963E+35
E
SYSTEM T OBJECT_TYP 1 4.5849E+35
E
SYSTEM T OBJECT_TYP 0 3.4943E+35
E
SYSTEM T SECONDARY 0 4.0500E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T STATUS 0 4.4786E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T SUBOBJECT_ 0 1.8867E+35
NAME
SYSTEM T SUBOBJECT_ 1 4.5340E+35
NAME
SYSTEM T TEMPORARY 0 4.0500E+35
SYSTEM T TEMPORARY 1 4.6211E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T TIMESTAMP 1 2.6059E+35
SYSTEM T TIMESTAMP 0 2.5558E+35
26 rows selected.
---透過執行包dbms_stats.gather_table_stats 再次收集，發現地段owner又出現了：
SQL> exec dbms_stats.gather_table_stats(user,'T');
PL/SQL procedure successfully completed.
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJEC 1 89403
T_ID
SYSTEM T DATA_OBJEC 0 0
T_ID
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_T 1 2457674.88
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
IME
SYSTEM T LAST_DDL_T 0 2452549.53
IME
SYSTEM T NAMESPACE 0 1
SYSTEM T NAMESPACE 1 64
SYSTEM T OBJECT_ID 1 89403
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAM 0 2.4504E+35
E
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OBJECT_NAM 1 6.2963E+35
E
SYSTEM T OBJECT_TYP 0 3.4943E+35
E
SYSTEM T OBJECT_TYP 1 4.5849E+35
E
SYSTEM T OWNER 0 3.3913E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OWNER 1 4.5831E+35
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T SECONDARY 0 4.0500E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T STATUS 0 4.4786E+35
SYSTEM T SUBOBJECT_ 1 4.5340E+35
NAME
SYSTEM T SUBOBJECT_ 0 1.8867E+35
NAME
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T TEMPORARY 1 4.6211E+35
SYSTEM T TEMPORARY 0 4.0500E+35
SYSTEM T TIMESTAMP 0 2.5558E+35
SYSTEM T TIMESTAMP 1 2.6059E+35
28 rows selected.
#共28條記錄。
以下是實驗過程：
---建立測試表：
SQL> create table t as select * from dba_objects;
Table created.
---呼叫系統的 dbms_stats包收集統計資訊：
SQL> exec dbms_stats.gather_table_stats(user,'T');
PL/SQL procedure successfully completed.
---此時資料庫為表上的所有欄位收集了預設的統計資訊，每個列兩個Bucket：
col column_name for a30
col owner for a10
col table_name for a10
col ENDPOINT_ACTUAL_VALUE for a10
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ------------------------------ --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJECT_ID 1 89403
SYSTEM T DATA_OBJECT_ID 0 0
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_TIME 1 2457674.88
SYSTEM T LAST_DDL_TIME 0 2452549.53
SYSTEM T NAMESPACE 0 1
SYSTEM T NAMESPACE 1 64
SYSTEM T OBJECT_ID 1 89403
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ------------------------------ --------------- -------------- ----------
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAME 0 2.4504E+35
SYSTEM T OBJECT_NAME 1 6.2963E+35
SYSTEM T OBJECT_TYPE 0 3.4943E+35
SYSTEM T OBJECT_TYPE 1 4.5849E+35
SYSTEM T OWNER 0 3.3913E+35
SYSTEM T OWNER 1 4.5831E+35
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T SECONDARY 0 4.0500E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T STATUS 0 4.4786E+35
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ------------------------------ --------------- -------------- ----------
SYSTEM T SUBOBJECT_NAME 1 4.5340E+35
SYSTEM T SUBOBJECT_NAME 0 1.8867E+35
SYSTEM T TEMPORARY 1 4.6211E+35
SYSTEM T TEMPORARY 0 4.0500E+35
SYSTEM T TIMESTAMP 0 2.5558E+35
SYSTEM T TIMESTAMP 1 2.6059E+35
28 rows selected.
#共28條記錄。
---同時，列的低值、高值等資訊會被收集記錄在dba_tab_col_statistics中：
SQL> set linesize 150;
SQL> select table_name,column_name,num_distinct,low_value,high_value,DENSITY
from dba_tab_col_statistics where owner='SYSTEM' and table_name='T';
TABLE_NAME COLUMN_NAM NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY
---------- ---------- ------------ ------------------------------ ------------------------------ ----------
T OWNER 32 415045585F303330323030 584442 .03125
T OBJECT_NAM 52336 2F31303030333233645F44656C6567 794362437253756253616D706C696E .000019107
E 617465496E766F636174696F6E4861 67547970653232395F54
T SUBOBJECT_ 148 2456534E5F31 575248245F5741495453545F323338 .006756757
NAME 3739363238335F30
T OBJECT_ID 87106 C103 C3095F04 .00001148
T DATA_OBJEC 9218 80 C3095F04 .000108483
T_ID
TABLE_NAME COLUMN_NAM NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY
---------- ---------- ------------ ------------------------------ ------------------------------ ----------
T OBJECT_TYP 45 434C5553544552 584D4C20534348454D41 .022222222
E
T CREATED 949 787108180C2624 78740A0C160334 .001053741
T LAST_DDL_T 1057 78660A010D2A32 78740A0C160334 .000946074
IME
T TIMESTAMP 1094 313939302D30382D32363A31313A32 323031362D31302D31323A32313A30 .000914077
353A3030 323A3531
T STATUS 1 56414C4944 56414C4944 1
TABLE_NAME COLUMN_NAM NUM_DISTINCT LOW_VALUE HIGH_VALUE DENSITY
---------- ---------- ------------ ------------------------------ ------------------------------ ----------
T TEMPORARY 2 4E 59 .5
T GENERATED 2 4E 59 .5
T SECONDARY 2 4E 59 .5
T NAMESPACE 21 C102 C141 .047619048
T EDITION_NA 0 0
ME
15 rows selected.
---收集所有欄位的直方圖統計資訊：
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt => 'for all columns size 1');
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.gather_table_stats(user,'T',method_opt=>'for columns owner size 1');
PL/SQL procedure successfully completed.
---刪除以上的兩個引數之後：
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJEC 1 89403
T_ID
SYSTEM T DATA_OBJEC 0 0
T_ID
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_T 1 2457674.88
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
IME
SYSTEM T LAST_DDL_T 0 2452549.53
IME
SYSTEM T NAMESPACE 0 1
SYSTEM T NAMESPACE 1 64
SYSTEM T OBJECT_ID 1 89403
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAM 0 2.4504E+35
E
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OBJECT_NAM 1 6.2963E+35
E
SYSTEM T OBJECT_TYP 0 3.4943E+35
E
SYSTEM T OBJECT_TYP 1 4.5849E+35
E
SYSTEM T OWNER 0 3.3913E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OWNER 1 4.5831E+35
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T SECONDARY 0 4.0500E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T STATUS 0 4.4786E+35
SYSTEM T SUBOBJECT_ 1 4.5340E+35
NAME
#共28條記錄。
--- 透過dbms_stats.delete_column_stats包刪除owner欄位：
SQL> exec dbms_stats.delete_column_stats(user,'T','OWNER');
PL/SQL procedure successfully completed.
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJEC 1 89403
T_ID
SYSTEM T DATA_OBJEC 0 0
T_ID
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_T 1 2457674.88
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
IME
SYSTEM T LAST_DDL_T 0 2452549.53
IME
SYSTEM T NAMESPACE 1 64
SYSTEM T NAMESPACE 0 1
SYSTEM T OBJECT_ID 1 89403
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAM 0 2.4504E+35
E
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OBJECT_NAM 1 6.2963E+35
E
SYSTEM T OBJECT_TYP 1 4.5849E+35
E
SYSTEM T OBJECT_TYP 0 3.4943E+35
E
SYSTEM T SECONDARY 0 4.0500E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T STATUS 0 4.4786E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T SUBOBJECT_ 0 1.8867E+35
NAME
SYSTEM T SUBOBJECT_ 1 4.5340E+35
NAME
SYSTEM T TEMPORARY 0 4.0500E+35
SYSTEM T TEMPORARY 1 4.6211E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T TIMESTAMP 1 2.6059E+35
SYSTEM T TIMESTAMP 0 2.5558E+35
26 rows selected.
---透過執行包dbms_stats.gather_table_stats 再次收集，發現地段owner又出現了：
SQL> exec dbms_stats.gather_table_stats(user,'T');
PL/SQL procedure successfully completed.
SQL> select * from dba_tab_histograms where table_name='T' and owner='SYSTEM' order by 3;
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T CREATED 1 2457674.88
SYSTEM T CREATED 0 2456529.48
SYSTEM T DATA_OBJEC 1 89403
T_ID
SYSTEM T DATA_OBJEC 0 0
T_ID
SYSTEM T GENERATED 0 4.0500E+35
SYSTEM T GENERATED 1 4.6211E+35
SYSTEM T LAST_DDL_T 1 2457674.88
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
IME
SYSTEM T LAST_DDL_T 0 2452549.53
IME
SYSTEM T NAMESPACE 0 1
SYSTEM T NAMESPACE 1 64
SYSTEM T OBJECT_ID 1 89403
SYSTEM T OBJECT_ID 0 2
SYSTEM T OBJECT_NAM 0 2.4504E+35
E
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OBJECT_NAM 1 6.2963E+35
E
SYSTEM T OBJECT_TYP 0 3.4943E+35
E
SYSTEM T OBJECT_TYP 1 4.5849E+35
E
SYSTEM T OWNER 0 3.3913E+35
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T OWNER 1 4.5831E+35
SYSTEM T SECONDARY 1 4.6211E+35
SYSTEM T SECONDARY 0 4.0500E+35
SYSTEM T STATUS 1 4.4786E+35
SYSTEM T STATUS 0 4.4786E+35
SYSTEM T SUBOBJECT_ 1 4.5340E+35
NAME
SYSTEM T SUBOBJECT_ 0 1.8867E+35
NAME
OWNER TABLE_NAME COLUMN_NAM ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
---------- ---------- ---------- --------------- -------------- ----------
SYSTEM T TEMPORARY 1 4.6211E+35
SYSTEM T TEMPORARY 0 4.0500E+35
SYSTEM T TIMESTAMP 0 2.5558E+35
SYSTEM T TIMESTAMP 1 2.6059E+35
28 rows selected.
#共28條記錄。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31392094/viewspace-2129903/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle的自動統計資訊不收集直方圖的資訊Oracle直方圖
- 收集資料庫統計資訊需要收集直方圖資訊.資料庫直方圖
- oracle統計資訊和直方圖Oracle直方圖
- 收集直方圖及檢視直方圖資訊直方圖
- Oracle直方圖統計資訊的應用Oracle直方圖
- [轉] oracle統計資訊(statistics)和直方圖(histogram)Oracle直方圖Histogram
- 關於列的直方圖統計資訊直方圖
- 微課sql最佳化(7)、統計資訊收集(5)-關於直方圖SQL直方圖
- 在收集統計資訊時指定method_opt=>.. size auto 時，有可能不收集直方圖直方圖
- Oracle收集統計資訊Oracle
- Oracle 統計資訊收集Oracle
- 收集oracle統計資訊Oracle
- ORACLE 收集統計資訊Oracle
- col_usage$與直方圖的收集直方圖
- 【統計資訊】Oracle常用的收集統計資訊方式Oracle
- oracle 直方圖Oracle直方圖
- ORACLE 統計資訊的收集與管理Oracle
- oracle直方圖使用Oracle直方圖
- Oracle直方圖解析Oracle直方圖圖解
- Oracle統計資訊自動收集Oracle
- oracle收集統計資訊job停止Oracle
- [Oracle] Oracle收集統計資訊的取樣比例Oracle
- Oracle資料遷移後由列的直方圖統計資訊引起的執行計劃異常Oracle直方圖
- 重新收集oracle表的統計資訊Oracle
- Oracle統計資訊的收集和維護Oracle
- Oracle直方圖詳解Oracle直方圖
- Oracle多列統計資訊與直方圖對有關聯多列查詢影響Oracle直方圖
- oracle 統計資訊檢視與收集Oracle
- oracle 11g統計資訊收集Oracle
- oracle直方圖筆記-轉Oracle直方圖筆記
- （轉）Oracle直方圖詳解Oracle直方圖
- Oracle直方圖詳解(ZT)Oracle直方圖
- oracle收集直方圖時 method_opt中引數 auto跟skewonly的區別Oracle直方圖
- Oracle運維指令碼-收集統計資訊Oracle運維指令碼
- 關於oracle自動收集統計資訊Oracle
- [統計資訊系列7] Oracle 11g的自動統計資訊收集Oracle
- Oracle11g 統計資訊-----統計資訊自動收集任務Oracle
- Oracle11g 統計資訊——統計資訊自動收集任務Oracle