在8.1.7中，可以用exec dbms_system.set_sql_trace_in_session(7,284,true);

显示全部楼层 · 2005-10-30 17:05:33

或者有什麼類似的功能包呢？我想實現的功能是我知道一個user的sid,serial#,然後我在另外一台機器通過trace看一下它的執行情況.

千问 · 2005-10-30 17:05:33

It's ok.

千问 · 2005-10-30 17:05:33

8.1.7好像不行吧！
SQL> exec dbms_system.set_sql_trace_in_session(7,284,true);
BEGIN dbms_system.set_sql_trace_in_session(7,284,true); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

在8.1.7裡面有類似行的功能嗎？

千问 · 2005-10-30 17:05:33

有

千问 · 2005-10-30 17:05:33

SQL> exec dbms_system.set_sql_trace_in_session(7,284,true);
BEGIN dbms_system.set_sql_trace_in_session(7,284,true); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

是不是没有权限
grant execute on sys.dbms_system to test;