使用oradebug開啟10046

1. [email protected]> oradebug setmypid  
2. Statement processed.  
3. [email protected]> oradebug unlimit  
4. Statement processed.  
5. [email protected]> oradebug event 10046 trace name context forever,level 8   
6. Statement processed.  
7. [email protected]> select * from hr.departments where department_id=10;  
8. DEPARTMENT_ID DEPARTMENT_NAME                MANAGER_ID LOCATION_ID  
9. ------------- ------------------------------ ---------- -----------  
10.            10 Administration                        200        1700  
11. [email protected]> oradebug tracefile_name  
12. /u01/app/oracle/admin/orcl/udump/orcl_ora_5234.trc  
13. [email protected]> oradebug event 10046 trace name context off  

1. Statement processed.  

轉載自http://blog.csdn.net/miyatang/article/details/8075785