SQL> oradebug setospid 3144
Oracle pid: 34, Unix process pid: 3144, image: oracle@ora11g.vnimos.org (TNS V1-V3)
SQL> oradebug unlimit;
Statement processed.
SQL> oradebug tracefile_name
/lihb716/diag/rdbms/orcl/orcl/trace/orcl_ora_3144.trc
SQL> oradebug session_event 10046 trace name context forever ,level 4
Statement processed.
SQL> oradebug event 10046 trace name context off
Statement processed.
Oracle pid: 34, Unix process pid: 3144, image: oracle@ora11g.vnimos.org (TNS V1-V3)
SQL> oradebug unlimit;
Statement processed.
SQL> oradebug tracefile_name
/lihb716/diag/rdbms/orcl/orcl/trace/orcl_ora_3144.trc
SQL> oradebug session_event 10046 trace name context forever ,level 4
Statement processed.
SQL> oradebug event 10046 trace name context off
Statement processed.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31441616/viewspace-2149465/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31441616/viewspace-2149465/