Business Intelligence et techniques avec Michel Preti

Voici la procédure : 

CREATE OR REPLACE PROCEDURE TEST.LANCER_STATS_SCHEMA(p_schema VARCHAR2)
IS
BEGIN
    SYS.DBMS_STATS.UNLOCK_SCHEMA_STATS(p_schema);
    SYS.DBMS_STATS.DELETE_SCHEMA_STATS(p_schema);
    SYS.DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME => p_schema, CASCADE => DBMS_STATS.AUTO_CASCADE, ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE, DEGREE => 4);
END;

 

Pour tester : 

BEGIN
 TEST.LANCER_STATS_SCHEMA('VENTE');
END;