How to set oracle events
alter session set events '[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : .......' 通过:符号,可以连续设置多个事件,也可以通过连续使用alter session set events 来设置多个...
ORACLE Diagnostic EVENTS
1. Query Events codeSET linesize 120SET feedback offSET SERVEROUTPUT ONDECLAREerr_msg VARCHAR2(120);BEGINdbms_output.enable (1000000);FOR err_num IN 10000..10999LOOPerr_msg := SQLERRM (-e...