桔子建站是什么平台,可做分析图的地图网站,做游戏用什么电脑系统下载网站,wordpress 头部修改10046事件说明10046事件是Oracle提供的内部事件#xff0c;是对SQL_TRACE的增强.10046事件可以设置以下四个级别:1 - 启用标准的SQL_TRACE功能,等价于sql_trace4 - Level 1 加上绑定值(bind values)8 - Level 1 等待事件跟踪12 - Level 1 Level 4 Level 8类似sql_trace是对SQL_TRACE的增强.10046事件可以设置以下四个级别:1 - 启用标准的SQL_TRACE功能,等价于sql_trace4 - Level 1 加上绑定值(bind values)8 - Level 1 等待事件跟踪12 - Level 1 Level 4 Level 8类似sql_trace10046事件可以在全局设置也可以在session级设置。开启10046事件SQL set autotrace offSQL SET LINESIZE 80 HEADING OFF FEEDBACK OFFSELECTRPAD(USERNAME : || s.username,80) ||RPAD(OSUSER : || s.osuser, 80) ||RPAD(PROGRAM : || s.program, 80) ||RPAD(SPID : || p.spid, 80) ||RPAD(SID : || s.sid, 80) ||RPAD(SERIAL# : || s.serial#, 80) ||RPAD(MACHINE : || s.machine, 80) ||RPAD(TERMINAL : || s.terminal,80) ||RPAD(SQL TEXT : || q.sql_text,80)FROM v$session s,v$process p,v$sql qWHERE s.paddr p.addrSQL 2 3 4 5 6 7 8 9 10 11 12 13 14 15 AND s.sid SIDAND s.sql_address q.address()AND s.sql_hash_value q.hash_value();16 17 Enter value for sid: 102USERNAME : STAROSUSER : oraclePROGRAM : sqlplusdb01 (TNS V1-V3)SPID : 26230SID : 102SERIAL# : 878MACHINE : db01TERMINAL :SQL TEXT : SELECT ROWID RID FROM COMMUL_INV WHERE ITEMNUMBER NOT LIKE 41%SQL oradebug setospid 26230Oracle pid: 55, Unix process pid: 26230, image: oracledb01 (TNS V1-V3)SQL oradebug event 10046 trace name context forever,level 12Statement processed.SQL oradebug event 10046 trace name context offStatement processed.SQL oradebug tracefile_name/home/oracle/admin/commdb/udump/ora_26230.trcSQLSQL alter session set events 10046 trace name context forever ,level 12 ;会话已更改。关闭10046事件SQL alter session set events 10046 trace name context off ;会话已更改。SQL exec dbms_system.set_SQL_TRACE_in_session(127,31923,true);SQL select * from dual;SQL exec dbms_system.set_SQL_TRACE_in_session(127,31923,false);当我们使用sql_trace/10046等事件进行进程跟踪时会生成跟踪文件.跟踪文件名称由以下几部分组成:ora.trc以下脚本用户获得跟踪文件名称:---- 当前 session xmlnamespace prefix o /SELECT d.value|| / ||lower(rtrim(i.instance, chr( 0 )))|| ora ||p.spid|| .trc trace_file_namefrom( select p.spid from v$mystat m,v$session s, v$process pwhere m.statistic# 1 and s.sid m.sid and p.addr s.paddr) p,( select t.instance from v$thread t,v$parameter vwhere v.name thread and (v.value 0 or t.thread# to_number(v.value))) i,( select value from v$parameter where name user_dump_dest ) d;---- 其他用户 sessionSELECT d.value|| / ||lower(rtrim(i.instance, chr( 0 )))|| ora ||p.spid|| .trc trace_file_namefrom( select p.spid from v$session s, v$process pwhere s.sid 127 and s. SERIAL# 31923 and p.addr s.paddr) p,( select t.instance from v$thread t,v$parameter vwhere v.name thread and (v.value 0 or t.thread# to_number(v.value))) i,( select value from v$parameter where name user_dump_dest ) d;SELECT a.VALUE|| b.symbol|| c.instance_name|| ora|| d.spid|| .trc trace_fileFROM (SELECT VALUEFROM v$parameterWHERE NAME user_dump_dest) a,(SELECT SUBSTR (VALUE, -6, 1) symbolFROM v$parameterWHERE NAME user_dump_dest) b,(SELECT instance_nameFROM v$instance) c,(SELECT spidFROM v$session s, v$process p, v$mystat mWHERE s.paddr p.addr AND s.SID m.SID AND m.statistic# 0) d/SQL select sid,serial#,username from v$session2 where username is not null;SID SERIAL# USERNAME8 2041 SYS9 437 EYGLE设置跟踪:SQL exec dbms_system.set_sql_trace_in_session(9,437,true)PL/SQL procedure successfully completed.....可以等候片刻跟踪session执行任务,捕获sql操作.......停止跟踪:SQL exec dbms_system.set_sql_trace_in_session(9,437,false)PL/SQL procedure successfully completed.执行跟踪:SQL exec dbms_system.set_ev(9,437,10046,8,eygle);PL/SQL procedure successfully completed.结束跟踪:SQL exec dbms_system.set_ev(9,437,10046,0,eygle);PL/SQL procedure successfully completed.当我们通过alter session的方式设置了sql_trace,这个设置是不能通过show parameter的方式得到的,我们需要通过dbms_system.read_ev来获取SQL set feedback offSQL set serveroutput onSQL declare2 event_level number;3 begin4 for event_number in 10000..10999 loop5 sys.dbms_system.read_ev(event_number, event_level);6 if (event_level 0) then7 sys.dbms_output.put_line(8 Event ||9 to_char(event_number) ||10 is set at level ||11 to_char(event_level)12 );13 end if;14 end loop;15 end;16 /Event 10046 is set at level 1
