SCOTT@ prod1>select sid from v$mystat where rownum=1;
SID
----------
61
SCOTT@ prod1>select sid,serial# from v$session where sid=61;
SID SERIAL#
---------- ----------
61 1779
SYS@ prod1>exec dbms_system.set_sql_trace_in_session(61,1779,true);
PL/SQL procedure successfully completed.
SYS@ prod1>exec dbms_system.set_sql_trace_in_session(61,1779,false);
PL/SQL procedure successfully completed.
SYS@ prod1>select value from v$diag_info where name = 'Default Trace File';
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/prod/prod1/trace/prod1_ora_20239.trc
SID
----------
61
SCOTT@ prod1>select sid,serial# from v$session where sid=61;
SID SERIAL#
---------- ----------
61 1779
SYS@ prod1>exec dbms_system.set_sql_trace_in_session(61,1779,true);
PL/SQL procedure successfully completed.
SYS@ prod1>exec dbms_system.set_sql_trace_in_session(61,1779,false);
PL/SQL procedure successfully completed.
SYS@ prod1>select value from v$diag_info where name = 'Default Trace File';
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/prod/prod1/trace/prod1_ora_20239.trc
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29108064/viewspace-2125498/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
网络配置yum源
请登录后发表评论
登录
全部评论
