配置sqlplus的AUTOTRACE
以管理员身份运行cmd
www.2cto.com
1
cd D:\app\wujiahua\product\11oracle账号.2.0\dbhome_1\RDBMS\ADMIN
2
sqlplus /nolog
3
connect system
4
manager
5
6
@utlxplan
7
create public synonym plan_table for plan_table
— 试具体情况 可以不执行(我的oracle11g执行就报错了) www.2cto.com
8
grant all on plan_table to public
创建并授权PLUSTRACE角色
1
cd D:\app\wujiahua\product\11.2.0\dbhome_1\sqlplus\admin
2
conn sys as sysdba
3
manager
4
@plustrce
5
grant plustrace to public
AUTOTRACE 报告
1
set autotrace on