Oracle 函数收集表最新分区的统计信息

create or replace FUNCTION ANALYZE_TABLE (P_TAB_NAME IN VARCHAR2) RETURN NUMBER IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
   DBMS_STATS.GATHER_TABLE_STATS(USER,P_TAB_NAME);
   RETURN 0;
END;

create or replace FUNCTION ANALYZE_PART_TABLE (P_TAB_NAME IN VARCHAR2) RETURN varchar2 IS
part_name varchar2(20);
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
   SELECT
    MAX(partition_name) KEEP(DENSE_RANK LAST ORDER BY partition_position)
FROM
    dba_tab_partitions
WHERE
    table_name = P_TAB_NAME;
DBMS_STATS.GATHER_TABLE_STATS(USER,P_TAB_NAME,P_PART_NAME);
   RETURN part_name;
END;