关闭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;