so different from 10gr2,more debugging events added.
for example , event 10949:
10949, 00000, “Disable autotune direct path read for full table scan”
AND
10978, 00000, “general event for materialized view logs”
you can view the event list from HERE.
[…] 设置event 10949可以避免采用直接路径读取方式.关于该事件可以参见这里. SQL> select count(*) from tv; COUNT(*) ———- 300000 SQL> select vm.sid, vs.name, […]