首页 > 数据库 > Oracle > The DBMS_System Package

The DBMS_System Package

Oracle 作者:lsxlong123 时间:2014-03-28 14:50:58 0 删除 编辑

The DBMS_System Package

The DBMS_System package contains a number of routines that can be useful on occasion. Oracle clearly state that these routines are not supported so proceed at your own risk.


Used to write messages to the alertlog and/or trace files.

EXEC DBMS_System.ksdwrt(n, message);
EXEC DBMS_System.ksdwrt(2, 'My Test Alertlog Message');

Where the value of "n" indicates the destination.

  • 1 - Write to trace file.
  • 2 - Write to alertlog.
  • 3 - Write to both.


Used to set trace on or off in another users session.

EXEC DBMS_System.Set_Sql_Trace_In_Session(sid, serial#, true );
EXEC DBMS_System.Set_Sql_Trace_In_Session(31, 97, true );

The values for SID and SERIAL# can be found using the V$SESSION view.


Used to set trace on for a specific event.

EXEC DBMS_System.Set_Ev(sid, serial#, event, level, name);
EXEC DBMS_System.Set_Ev(31, 97, 10046, 4, '');

Where level indicates the following levels of trace.

  • 1 - Standard SQL_TRACE functionality.
  • 4 - As level 1 plus tracing of bind variables.
  • 8 - As level 1 plus wait events.
  • 12 - As level 1 plus bind variables and wait events.


Used to check if a specific event is currently being traced.

EXEC DBMS_System.Read_Ev(event, output);

If output = 1 the event is being traced.

Hope this helps. Regards Tim...


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: 删除大表数据
请登录后发表评论 登录


  • 博文量
  • 访问量