关闭11g新特性

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;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21492320/viewspace-1058851/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21492320/viewspace-1058851/