如何在SQL*PLUS中使用Autotrace?

来源:互联网 发布:eclipse php插件下载 编辑:程序博客网 时间:2024/05/16 05:09

SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql
SQL> create public synonym plan_table for plan_table;
SQL> grant all on plan_table to public;
SQL> conn sys
SQL> @$ORACLE_HOME/sqlplus/admin/plustrce
SQL> grant plustrace to public;

SQL> SET AUTOTRACE OFF | ON EXPLAIN | ON STATISTICS | ON | TRACEONLY | TRACE EXPLAIN

原创粉丝点击