Oracle Statistical information Collection

Statistical information Collection

1: Create Analysis Table

$ cd $ORACLE _home/rdbms/admin

$ sqlplus/as SYSDBA

> @utlxplan. SQL


2: For convenience, you can create a synonym table ( by default only the SYS user can use )
sql> create public synonym plan_tables for plan_table;


3: Give the table permissions to everyone, or to the designated person
Sql> Grant all on plan_tables to public;


4: Create a plustrace role

$ cd $ORACLE _home/sqlplus/admin

$ sqlplus/as SYSDBA

> @plustrce. SQL


5: Give it permission to public
Sql> Grant plustrace to public;


6: Set display mode
Sql> set Autotrace off; # #在默认中是这个, do not show autotrace
Sql> set Autotrace explain; # #只显示优化器执行路径
sql> set Autotrace traceonly; # #不现实用户的查询输出

Sql> set autotrace on; # #报告显示优化器执行路径

Oracle Statistical information Collection