Oracle settting up autotrace in sql/qlus
1. Execute cd $ORACLE_HOME/rdbms/admin.2. Log into SQL*Plus as any user with create table and create public synonym privileges.
3. Run @utlxplan to create a plan_table for use by autotrace.
4. Run create public synonym plan_table for plan_table, so that everyone can access
this table without specifying a schema.
5. Run grant all on plan_table to public, so that everyone can use this table.
6. Exit SQL*Plus and change directories as follows: cd $ORACLE_HOME/sqlplus/admin.
7. Log into SQL*Plus as SYSDBA.
8. Run @plustrce.
9. Run grant plustrace to public.
set AUTOTRACE traceonly
set AUTOTRACE off
页:
[1]