ORACLE 数据收集20181012 date DBMS_STATS.GATHER_TABLE_STATS

select  a.sql_id,b.sql_text,a.* from v$session a,v$sql where a.sql_id=b.sql_id
exec DBMS_STATS.GATHER_TABLE_STATS('stg','TEMP_MO');

 grant select on SALE_IN_NOTICE_SAP_LINE to public;

 

delete FROM OUT_MO_WEBSERVICE a  ---备份表
where a.adddate < to_date('20181024080000','yyyymmddhh24miss')
AND to_char(AB.AVAILABLEDATE, 'yyyy-mm-dd ') =to_char(SYSDATE+3, 'yyyy-mm-dd ')