Set the autotrace of Sqlplus

1.CD D:\Oracle11gR2\product\11.2.0\dbhome_1\rdbms\admin; --[oracle_home]/rdbms/admin

2.sqlplus System/[email protected]--Login As System

[Email protected];

4.create public synonym plan_table for plan_table;

5.grant all on plan_table to public;

Create and grant the Plustrace role.

1.CD D:\oracle11gr2\product\11.2.0\dbhome_1\sqlplus\admin;--[oracle_home]/sqlplus/admin

2.sqlplus Sys/sys as [email protected]-Login as SYS or SYSDBA there may be errors ORA-28009 This is not logged in with the DBA himself Baidu will know.

[Email protected];

4.grant plustrace to public;

You can set Autotrace system variables to control the report.

Set Autotrace off; The Autotrace report is not generated. Default.

Set autotrace on explain; The report shows only the optimizer execution path.

Set autotrace on statistics; reports show only execution statistics for SQL statements.

Set autotrace on; The report consists of the two above.

Set Autotrace traceonly; is similar to set autotrace on, but does not display the user's query output.

Set the autotrace of Sqlplus