oracle统计信息

  1. create table t2 as select * from dba_objects;

    建网站原本是网站策划师、网络程序员、网页设计师等,应用各种网络程序开发技术和网页设计技术配合操作的协同工作。创新互联建站专业提供网站制作、成都网站设计,网页设计,网站制作(企业站、成都响应式网站建设、电商门户网站)等服务,从网站深度策划、搜索引擎友好度优化到用户体验的提升,我们力求做到极致!

  建索引:

create index idx_t2 on t2(object_id);

2.收集T2的表所有列和表上所有索引的统计信息:

exec dbms_stats.gather_table_stats(ownname=>'SYS',tabname=>'T2',estimate_percent=>100,cascade=>true,degree=>4);

degree表示并行度;

3.查看统计信息,脚本(soxi.txt)

Please enter Name of Table Owner (Null = SYS): SYS

Please enter Table Name to show Statistics for: T2

***********

Table Level

***********

Table Number       Empty AverageChain Average Global User    Sample Date

Name       of Rows Blocks       Blocks   SpaceCount Row Len Stats  Stats      Size MM-DD-YYYY

--------------- -------------- -------- ------------ ------- -------- ------- ------ ------ -------------- ----------

T2 87,361  1,246   0   0    0   98 YES    NO    87,361 07-07-2015

Column  Column       Distinct Number     Number Global User Sample Date

Name  Details Values Density Buckets      Nulls Stats  Stats   Size MM-DD-YYYY

------------------------- ------------------------ ------------ ------- ------- ---------- ------ ------ -------------- ----------

OWNER  VARCHAR2(30)     31       0       1 0 YES  NO 87,361 07-07-2015

OBJECT_NAME  VARCHAR2(128) 52,669       0       1 0 YES  NO 87,361 07-07-2015

SUBOBJECT_NAME  VARCHAR2(30)    194       0       1     86,760 YES  NO    601 07-07-2015

OBJECT_ID  NUMBER(22) 87,361       0       1 0 YES  NO 87,361 07-07-2015

DATA_OBJECT_ID  NUMBER(22)  9,348       0       1     77,945 YES  NO  9,416 07-07-2015

OBJECT_TYPE  VARCHAR2(19)     45       0       1 0 YES  NO 87,361 07-07-2015

CREATED  DATE  1,244       0       1 0 YES  NO 87,361 07-07-2015

LAST_DDL_TIME  DATE  1,365       0       1 0 YES  NO 87,361 07-07-2015

TIMESTAMP  VARCHAR2(19)  1,440       0       1 0 YES  NO 87,361 07-07-2015

STATUS  VARCHAR2(7)      2       1       1 0 YES  NO 87,361 07-07-2015

TEMPORARY  VARCHAR2(1)      2       1       1 0 YES  NO 87,361 07-07-2015

GENERATED  VARCHAR2(1)      2       1       1 0 YES  NO 87,361 07-07-2015

SECONDARY  VARCHAR2(1)      2       1       1 0 YES  NO 87,361 07-07-2015

NAMESPACE  NUMBER(22)     21       0       1 0 YES  NO 87,361 07-07-2015

EDITION_NAME  VARCHAR2(30)      0       0       0     87,361 YES  NO 07-07-2015

     B       Average   Average

Index   Tree Leaf   Distinct    Number Leaf Blocks Data BlocksCluster Global User      Sample Date

Name Unique  Level Blks       Keys   of Rows     Per Key   Per Key Factor Stats  Stats Size MM-DD-YYYY

--------------- --------- ----- ---- -------------- -------------- ----------- ----------- ------------ ------ ------ -------------- ----------

IDX_T2 NONUNIQUE     1  194     87,361    87,361     1 1  1,385 YES    NO      87,361 07-07-2015

Index Column   Col Column

Name Name   Pos Details

--------------- ------------------------- ---- ------------------------

IDX_T2 OBJECT_ID     1 NUMBER(22)

***************

Partition Level

***************

***************

SubPartition Level

***************


网站题目:oracle统计信息
新闻来源:http://scyanting.com/article/poocgh.html