重置统计信息
SET SERVEROUTPUT ONBEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'EGISNBUDATA',TABNAME => 'NBU_QUOTATE_CC_ATTR_VALUE',METHOD_OPT => 'FOR ALL COLUMNS SIZE REPEAT',DEGREE => 1,CASCADE => TRUE,NO_INVALIDATE => FALSE);END;/declarev_last_analyzed date;BEGINSELECT LAST_ANALYZED INTO V_LAST_ANALYZED FROM DBA_TABLES WHERE OWNER = 'EGISNBUDATA' AND TABLE_NAME = 'NBU_QUOTATE_CC_ATTR_VALUE'; IF V_LAST_ANALYZED >= TRUNC(SYSDATE) THEN DBMS_OUTPUT.PUT_LINE('NBU_QUOTATE_CC_ATTR_VALUE表统计信息收集成功!');ELSEDBMS_OUTPUT.PUT_LINE('NBU_QUOTATE_CC_ATTR_VALUE表统计信息收集失败,请排查原因!');END IF;END;/------------delete_statistics_if_num_rows_is_zero ---------------DECLARE V_COUNT NUMBER;BEGIN SELECT num_rowsINTO V_COUNT FROM DBA_TABLESWHERE owner = 'EGISNBUDATA' AND table_name = 'NBU_QUOTATE_CC_ATTR_VALUE';if v_count=0 then BEGIN DBMS_STATS.DELETE_TABLE_STATS(OWNNAME => 'EGISNBUDATA',TABNAME => 'NBU_QUOTATE_CC_ATTR_VALUE',CASCADE_COLUMNS => TRUE ,CASCADE_INDEXES => TRUE ,CASCADE_PARTS => TRUE );END;END IF;END;/------------delete_statistics_if_num_rows_is_zero ---------------