CREATE OR REPLACE PROCEDURE PRO_Analyze_Table(p_name VARCHAR2,
p_method VARCHAR2 := 'ESTIMATE',
p_estimate_rows NUMBER := null,
p_estimate_percent NUMBER := 50,
p_method_opt VARCHAR2 := 'FOR TABLE',
p_type VARCHAR2 := 'TABLE',
p_partname VARCHAR2 := null)
AUTHID CURRENT_USER AS
p_schema VARCHAR2(2000) := USER;
BEGIN
/* p_type TABLE, CLUSTER or INDEX */
DBMS_DDL.ANALYZE_OBJECT(p_type,
p_schema,
p_name,
p_method,
p_estimate_rows,
p_estimate_percent,
p_method_opt,
p_partname);
END ;