通过sql_trace=true和下面的方法 ,dba_enabled_traces 里都没有数据。
SQL> select sid,serial# from v$session where sid=159;
SID SERIAL#
---------- ----------
159 18
SQL> begin
--dbms_monitor.session_trace_disable(session_id=>139,serial_num=>159);
dbms_monitor.session_trace_enable(session_id=>159,serial_num=>18,waits=>TRUE);
end;
/ 2 3 4 5
PL/SQL procedure successfully completed.
SQL> select sql_trace from v$session where sid=159;
SQL_TRACE
----------------
ENABLED
SQL> select count(*) from dba_enabled_traces;
COUNT(*)
----------
0
用下面的方法 ,dba_enabled_traces里有数据:
SQL> exec dbms_session.set_identifier('aaaa');
PL/SQL procedure successfully completed.
SQL> exec dbms_monitor.client_id_trace_enable(client_id => 'aaaa',waits => true);
PL/SQL procedure successfully completed.
SQL> select * from v$mystat where rownum=1;
SID STATISTIC# VALUE
---------- ---------- ----------
138 0 1
SQL> select sql_trace from v$session where sid=138;
SQL_TRACE
----------------
DISABLED
SQL> select count(*) from dba_enabled_traces;
COUNT(*)
----------
1
CLIENT_ID_TRACE_ENABLE Procedure
Enables the trace for a given Client Identifier globally for the database 这个是for database
SESSION_TRACE_ENABLE Procedure
Enables the trace for a given database session identifier (SID) on the local instance 这个是这个实例中的session
v$session里的值也可以反映出来 一些
dba_enabled_traces 不包含 会话 级别的
所以,会话级别的没有在 dba_enabled_traces里显示出来
bysong
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25099483/viewspace-774759/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25099483/viewspace-774759/