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.
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, […]