select sid,serial#,username,sql_trace, sql_trace_waits, sql_trace_binds
from v$session where username = 'PRAPP';
执行后
SID SERIAL# USERNAME SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS493 29278 PRAPP DISABLED FALSE FALSE
接着执行
exec DBMS_MONITOR.session_trace_enable(493,29278);
commit;
再执行
select sid,serial#,username,sql_trace, sql_trace_waits, sql_trace_binds
from v$session where username = 'PRAPP';
结果仍然为
SID SERIAL# USERNAME SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS493 29278 PRAPP DISABLED FALSE FALSE个人觉得应该是
SID SERIAL# USERNAME SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS493 29278 PRAPP ENABLED FALSE FALSE求高手点拨。
ORACLE版本是10
from v$session where username = 'PRAPP';
执行后
SID SERIAL# USERNAME SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS493 29278 PRAPP DISABLED FALSE FALSE
接着执行
exec DBMS_MONITOR.session_trace_enable(493,29278);
commit;
再执行
select sid,serial#,username,sql_trace, sql_trace_waits, sql_trace_binds
from v$session where username = 'PRAPP';
结果仍然为
SID SERIAL# USERNAME SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS493 29278 PRAPP DISABLED FALSE FALSE个人觉得应该是
SID SERIAL# USERNAME SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS493 29278 PRAPP ENABLED FALSE FALSE求高手点拨。
ORACLE版本是10
无语....
SQL> select * from v$mystat where rownum<2; SID STATISTIC# VALUE
---------- ---------- ----------
159 0 1
SQL> SELECT sid, serial#, username, sql_trace, sql_trace_waits, sql_trace_binds
2 FROM v$session t where t.SID=159; SID SERIAL# USERNAME SQL_TRAC SQL_T SQL_T
---------- ---------- ------------------------------ -------- ----- -----
159 22147 TEST DISABLED FALSE FALSESQL> 在另一会话中启用跟踪
SQL> select * from v$mystat where rownum<2; SID STATISTIC# VALUE
---------- ---------- ----------
137 0 1SQL> exec dbms_monitor.session_trace_enable(159,22147);PL/SQL 过程已成功完成。SQL> 执行跟踪后的会话信息
SQL> SELECT sid, serial#, username, sql_trace, sql_trace_waits, sql_trace_binds
2 FROM v$session t where t.SID=159; SID SERIAL# USERNAME SQL_TRAC SQL_T SQL_T
---------- ---------- ------------------------------ -------- ----- -----
159 22147 TEST ENABLED TRUE FALSESQL>
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production