system@9i > create or replace procedure anal_schema
  2  as
  3  begin
  4  DBMS_STATS.gather_schema_stats(ownname =>'SCOTT', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, cascade => TRUE);
  5  end;
  6  /

Procedure created.

system@9i > exec system.anal_schema;
BEGIN system.anal_schema; END;

*
ERROR at line 1:
ORA-20000: Insufficient privileges to analyze an object in Schema
ORA-06512: at "SYS.DBMS_STATS", line 9876
ORA-06512: at "SYS.DBMS_STATS", line 10041
ORA-06512: at "SYS.DBMS_STATS", line 10095
ORA-06512: at "SYS.DBMS_STATS", line 10072
ORA-06512: at "SYSTEM.ANAL_SCHEMA", line 4
ORA-06512: at line 1


system@9i > !sqlplus -s "sys/sys as sysdba"
grant analyze any to system;

Grant succeeded.

exit

system@9i > exec anal_schema;

PL/SQL procedure successfully completed.

system@9i > exec system.anal_schema;

PL/SQL procedure successfully completed.