Shulou(Shulou.com)06/01 Report--

Create table T2 as select * from dba_objects

Index:

Create index idx_t2 on T2 (object_id)

two。 Collect statistics for all columns of the T2 table and all indexes on the table:

Exec dbms_stats.gather_table_stats (ownname= > 'SYS',tabname= >' T _ 2 parallel recordings, cascades = > 100 minutes cascade= > true,degree= > 4)

Degree represents the degree of parallelism

3. View statistics, script (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 Average Chain Average Global User Sample Date

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

--

T2 87361 1246 000 98 YES NO 87361 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 01 0 YES NO 87361 07-07-2015

OBJECT_NAME VARCHAR2 52669 01 0 YES NO 87361 07-07-2015

SUBOBJECT_NAME VARCHAR2 (30) 194 01 86760 YES NO 601 07-07-2015

OBJECT_ID NUMBER (22) 87361 01 0 YES NO 87361 07-07-2015

DATA_OBJECT_ID NUMBER (22) 9348 01 77945 YES NO 9416 07-07-2015

OBJECT_TYPE VARCHAR2 (19) 45 01 0 YES NO 87361 07-07-2015

CREATED DATE 1244 01 0 YES NO 87361 07-07-2015

LAST_DDL_TIME DATE 1365 01 0 YES NO 87361 07-07-2015

TIMESTAMP VARCHAR2 (19) 1440 01 0 YES NO 87361 07-07-2015

STATUS VARCHAR2 (7) 2 1 1 0 YES NO 87361 07-07-2015

TEMPORARY VARCHAR2 (1) 2 1 1 0 YES NO 87361 07-07-2015

GENERATED VARCHAR2 (1) 2 1 1 0 YES NO 87361 07-07-2015

SECONDARY VARCHAR2 (1) 2 1 1 0 YES NO 87361 07-07-2015

NAMESPACE NUMBER (22) 21 01 0 YES NO 87361 07-07-2015

EDITION_NAME VARCHAR2 (30) 0 87361 YES NO 07-07-2015

B Average Average

Index Tree Leaf Distinct Number Leaf Blocks Data Blocks Cluster 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 87361 87361 1 1 1385 YES NO 87361 07-07-2015

Index Column Col Column

Name Name Pos Details

IDX_T2 OBJECT_ID 1 NUMBER (22)

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

Partition Level

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

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

SubPartition Level

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.