Set SQL PLUS AutoTrace

Set SQL plus AutoTrace Initial Setup1. Step 1: This is what I like to do to get AUTOTRACE working: • cd [ORACLE_HOME]/rdbms/admin www.2cto.com • log into SQL * Plus as SYSTEM • run @ utlxplan • run CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE; • run GRANT ALL ON PLAN_TABLE TO PUBLIC; 2. step 2 The next step is creating and granting the PLUSTRACE role: • cd [ORACLE_HOME]/sqlplus/admin • log into SQL * Plus as SYS Or as sysdba • run @ plustrce www.2cto.com • run grant plustrace to public; Again, you can replace PUBLIC in the GRANT command with some user if you want. can I run scripts in sqlplus? It indicates $ ORACLE_HOME. You can SET plblic to a user. in step 2, you must use SYS's description of several common options of Autotrace: set autotrace off ---------------- no AUTOTRACE report is generated, this is the default mode set autotrace on explain ------ AUTOTRACE only displays the optimizer execution path report set autotrace on statistics -- only displays the execution statistics set autotrace on ----------------- contains the execution plan and statistical information set autotrace traceonly ------ same as set autotrace on, however, the query output is not displayed.