[ORACE] Oracle trace 之二10046事件

session set events ‘10046 trace name context forever 12‘ --启用trace alter session set events ‘10046 trace name context off‘ --停止trace

     11g之后

    alter session set events ‘SQL_TRACE wait=true‘;

2.2 方法2    

SQL>     select sid,serial#,username from v$session where username is not null;

       SID    SERIAL# USERNAME
---------- ---------- --------------------------------------------------------------------------------------------------------------------------------
     3    62469 SYS
       217    44968 C##SAPR3
       395    39248 C##SAPR3
       596    21546 SYS

    exec dbms_system.set_ev(395,39248,10046,8,‘‘);    --启用trace
    exec dbms_system.set_ev(395,39248,10046,0,‘‘);    --停止trace
    
    ‘db file scattered read‘全表扫描
    db_file_multiblock_read_count 全表扫描时每次IO可以读取的数据块数量

 

[ORACE] Oracle trace 之二10046事件

标签：ever   执行   rom   sys   set   where   信息   contex   内核