| Oracle Autotrace Version 11.2.0.3 |
|---|
| General Information | |
| Create Plan Table | SQL> @?/rdbms/admin/catplan.sql |
| Create PLUSTRACE Role | SQL> @?/sqlplus/admin/plustrce.sql |
| Grant PLUSTRACE Role | GRANT plustrace TO <user_name>; |
| SQL> grant plustrace TO uwclass; | |
| Syntax and Demos | |
| Syntax | SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]] |
| Trace and Run | SQL> set autotrace on SQL> SELECT * FROM dual; |
| Trace Only | SQL> set autotrace traceonly SQL> SELECT * FROM dual; |
| Trace and Explain | SQL> set autotrace traceonly explain SQL> SELECT * FROM dual; |
| Trace and Statistics | SQL> set autotrace traceonly statistics SQL> SELECT * FROM dual; |
| Stop Tracing | SET AUTOTRACE OFF |
| SQL> set autotrace off | |
| Related Topics |
| DBMS_XPLAN |
| Explain Plan |
| Roles |
| Trace and TKPROF |
| This site is maintained by Dan Morgan. Last Updated: | This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2013 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||
