Raw Trace的收集方法
1. 打开Trace，Help > Diagnostics > Trace > Trace > Trace with Binds and Waits
Trace项代表的意思
- No Trace – turns trace off.
- Regular Trace – generates a regular SQL trace by performing the following statement:
ALTER SESSION SET SQL_TRACE = TRUE;
- Trace with Binds – writes bind variable values in the SQL trace file
- Trace with Waits – writes wait events in the SQL trace file
- Trace with Binds and Waits – writes both bind variable values and wait events in the SQL trace file
2.执行业务功能
3.关闭Trace，Help > Diagnostics > Trace > Trace > No Trace
系统会弹出一个窗口，告诉你Trace文件所在的目录。
这个目录实际上是数据库系统参数表(v$parameter)中的user_dump_dest的值，可以执行下边的SQL来找到Trace文件所在的目录
SELECT value FROM v$parameter WHERE name = \'user_dump_dest\'; Output:/slot/ems7061/oracle/db/tech_st/11.2.0/admin/az1mu213_rws60145rems/diag/rdbms/az1mu213/az1mu213/trace
trace文件名后边的那个数字是Database Server PID，也可以从Help>About中找到。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26687597/viewspace-1203755/ ，如需转载，请注明出处，否则将追究法律责任。
