alter system set event= '10949 trace name context forever, level 1' scope=spfile;
alter system set audit_trail=none;
ORA-10949: Disable autotune direct path read for full table scan
禁止sql tuning advisor
BEGIN
DBMS_AUTO_TASK_ADMIN.disable(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
select se.USERNAME,
se.OSUSER,
se.SID,
p.SPID,
su.BLOCKS * 8192/1024/1024 Space,
s.SQL_TEXT
from v$sort_usage su, v$session se, v$sqltext s, v$process p
where su.SESSION_ADDR = se.SADDR
and se.SQL_ADDRESS = s.ADDRESS
and se.SQL_HASH_VALUE = s.HASH_VALUE
and p.ADDR = se.PADDR;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21492320/viewspace-1058851/ ，如需转载，请注明出处，否则将追究法律责任。
