oracledbms_stats统计信息管理(四)
----- ------ ------------------
Date
MM-DD-YYYY
----------
INDEX_01 NONUNIQUE NO NO
Index Column Col Column
Name Name Pos Details
--------------- ------------------------- ---- ------------------------
INDEX_01 OBJECT_ID 1 NUMBER(22)
-----案例4：只统计表的信息、表所有列以及表所有索引的统计信息
begin
dbms_stats.gather_table_stats
(
ownname => 'SCOTT',
tabname => 'TT' ,
estimate_percent =>100 ,
cascade => true
);
end;
/
***********
Table Level
***********
Table Number Empty Average Chain Average Global User Sample Date
Name of Rows Blocks Blocks Space Count Row Len Stats Stats Size MM-DD-YYYY
--------------- ------------------ -------- ------------ ------- -------- ------- ------ ------ ------------------ ----------
TT 74,908 1,094 0 0 0 97 YES NO 74,908 12-25-2013
Column Column Distinct Number Number Global User Sample Date
Name Details Values Density Buckets Nulls Stats Stats Size MM-DD-YYYY
------------------------- ------------------------ ------------ ------- ------- ---------- ------ ------ ------------------ ----------
OWNER VARCHAR2(30) 23 0 1 0 YES N 74,908 12-25-2013
OBJECT_NAME VARCHAR2(128) 46,257 0 1 0 YES N 74,908 12-25-2013
SUBOBJECT_NAME VARCHAR2(30) 256 0 1 74,301 YES N607 12-25-2013
OBJECT_ID NUMBER(22) 74,908 0 1 0 YES N 74,908 12-25-2013
DATA_OBJECT_ID NUMBER(22) 9,385 0 1 65,483 YES N 9,425 12-25-2013
OBJECT_TYPE VARCHAR2(19) 44 0 1 0 YES N 74,908 12-25-2013
CREATED DATE 1,139 0 1 0 YES N 74,908 12-25-2013
LAST_DDL_TIME DATE 1,220 0 1 0 YES N 74,908 12-25-2013
TIMESTAMP VARCHAR2(19) 1,303 0 1 0 YES N 74,908 12-25-2013
STATUS VARCHAR2(7) 1 1 1 0 YES N 74,908 12-25-2013
TEMPORARY VARCHAR2(1) 2 1 1 0 YES N 74,908 12-25-2013
GENERATED VARCHAR2(1) 2 1 1 0 YES N 74,908 12-25-2013
SECONDARY VARCHAR2(1) 2 1 1 0 YES N 74,908 12-25-2013
NAMESPACE NUMBER(22) 20 0 1 0 YES N 74,908 12-25-2013
EDITION_NAME VARCHAR2(30) 0 0 0 74,908 YES N 12-25-2013
B Average Average
Index Tree Leaf Distinct Number Leaf Blocks Data Blocks Cluster Global User Sample
Name Unique Level Blks Keys of Rows Per Key Per Key Factor Stats Stats Size
--------------- --------- ----- ---- -------------- ------------------ ----------- ----------- ------------ ------ ------ ------------------
Date
MM-DD-YYYY
----------
INDEX_01 NONUNIQUE 1 166 74,908 74,908 1 1 1,177 YES NO 74,908
12-25-2013
Index Column Col Column
Name Name Pos Details
--------------- ------------------------- ---- ------------------------
INDEX_01 OBJECT_ID 1 NUMBER(22)
***************
-----案例5：删除表的统计信息
begin
dbms_stats.delete_table_stats
(
ownname =>
'SCOTT',
tabname => 'TT'
);
end;
/
***********
Table Level
***********
Table Number Empty Average Chain Average Global User Sample Date
Name of Rows Blocks Blocks Space Count Row Len Stats Stats Size MM-DD-YYYY
--------------- ------------------ -------- ------------ ------- -------- ------- ------ ------ ------------------ ----------
TT NO NO
Column Column Distinct Number Number Global User Sample Date
Name Details Values Density Buckets Nulls Stats Stats Size MM-DD-YYYY
------------------------- ------------------------ ------------ ------- ------- ------