Use Dbms_system to track other session

Dbms_system is an internal package that is recommended for use under official guidance.

sql> desc dbms_systemprocedure add_parameter_value Argument Name Type in/out defaul T?                -------------------------------------------------------------------parname VARCHAR2      In VALUE VARCHAR2 in SCOPE VARCHAR2 in Default SID VARCHAR2 in default POSITION binary_i Nteger in Defaultprocedure dist_txn_sync Argument Name Type in/out defaul T?                  -------------------------------------------------------------------inst_num Number Inprocedure get_env Argument Name Type in/out Default?                -------------------------------------------------------------------VAR VARCHAR2 In VAL VARCHAR2 outprocedure kcfrmsprocedure ksdddtprocedure ksdflsprocedure ksdind Argument Name Type In/out Default?          -------------------------------------------------------------------LVL Binary_integer Inprocedure ksdwrt Argument Name Type in/out Default?          -------------------------------------------------------------------DEST Binary_integer                    In TST VARCHAR2 inprocedure Read_ev Argument Name Type In/out Default?          -------------------------------------------------------------------IEV Binary_integer                  In OEV binary_integer outprocedure remove_parameter_value Argument Name Type in/out Default? ------------------------------ ----------------------- --------------parname VARCHAR2 in VALUE VARCHAR2                In SCOPE VARCHAR2 in DEFAULT SID VARCHAR2 In Defaultprocedure remove_parameter_value Argument Name Type in/out Default ?                -------------------------------------------------------------------parname VARCHAR2      In POSITION Binary_integer in SCOPE VARCHAR2 in DEFAULT SID VARCHAR2 in Defaultprocedure set_bool_param_in_session Argu ment Name Type in/out Default?                  -------------------------------------------------------------------SID Number      In serial# number in Parnam                   VARCHAR2 in BVAL BOOLEAN inprocedure Set_ev Ar Gument Name Type in/out Default?          -------------------------------------------------------------------SI Binary_integer  In SE Binary_integer in EV Binary_integer in LE Binary_integer in NM VARCHAR2 inproced URE set_int_param_in_session Argument Name Type in/out Default?                  -------------------------------------------------------------------SID Number  In serial# number in Parnam VARCHAR2 in Intval Binary_integer inprocedure set_sql_trace_in_session argumeNT Name Type in/out Default?                  -------------------------------------------------------------------SID Number In serial# number in Sql_trace BOOLEAN in PROCEDURE wait_for_event Argument Name Type in/out Default?                -------------------------------------------------------------------EVENT VARCHAR2 In extended_id Binary_integer in TIMEOUT Binary_integer in  Sql>

#查看10046事件的追踪级别

Sql> declare lev Integer;  2  begin  3     Dbms_system.read_ev (' 10046 ', Lev);  4     Dbms_output.put_line (Lev);  5  end;  6  

#对指定session开启sql_trace追踪

EXEC dbms_system.set_sql_trace_in_session (<sid>,<serial#>,true);---Turn on sql_trace trace exec Dbms_system.set _sql_trace_in_session (<SID>,<SERIAL#>,FALSE);---turn off sql_trace tracking

#对指定session开启10046追踪

Dbms_system.set_ev (si in Binary_integer,  --session Idse in Binary_integer,  --session serial Numberev in Binary_ INTEGER,  --event number between 10000 and 10999le in Binary_integer,  --event levelnm in VARCHAR2); EXEC dbms_syst Em.set_ev (<sid>,<serial#>,12, ' ybb ');    ----Turn on the 12-level tracking exec Dbms_system.set_ev (<sid>,<serial#>,0, ' ybb ');    -----Turn Off tracing

Use Dbms_system to track other session