procedure P1 ( tablename in varchar2) is
  begin
       dbms_stats.gather_table_stats('PRD_1', tabname => tablename, estimate_percent =>100, method_opt => 'for all indexed columns size auto', degree => dbms_stats.default_degree ,cascade => true);
  end;

  procedure P2 is
  begin
       . . .
       P1 ('ACCOUNT');
       . . .
  end;

begin
     P1 ('ACCOUNT');
end; 

SQL> host cat t.sql
CREATE TABLE t1 AS
WITH generator AS (
   SELECT --+materialize
          ROWNUM FROM all_objects
   WHERE ROWNUM <= 1582
)
SELECT ROWNUM ID, MOD(ROWNUM,100000) n1
FROM generator, generator;

CREATE OR REPLACE PROCEDURE p1 (
   tablename   IN   VARCHAR2
)
IS
BEGIN
   DBMS_STATS.gather_table_stats
                          (USER
                          ,tabname               => tablename
                          ,estimate_percent      => 100
                          ,method_opt            => 'for all indexed columns size auto'
                          ,DEGREE                => DBMS_STATS.default_degree
                          ,CASCADE               => TRUE
                          );
END;
/

CREATE OR REPLACE PROCEDURE p2
IS
BEGIN
   p1 ('T1');
END;
/

SET TIMING ON
BEGIN
   p2;
END;
/

BEGIN
   p1 ('T1');
END;
/

BEGIN
   DBMS_STATS.gather_table_stats
                          (USER
                          ,tabname               => 'T1'
                          ,estimate_percent      => 100
                          ,method_opt            => 'for all indexed columns size auto'
                          ,DEGREE                => DBMS_STATS.default_degree
                          ,CASCADE               => TRUE
                          );
END;
/
SQL> @t.sql

Table created.


Procedure created.


Procedure created.


PL/SQL procedure successfully completed.

Elapsed: 00:00:02.84

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.62

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.53

SQL> select count(*) from t1;

  COUNT(*)
----------
   2502724

Elapsed: 00:00:00.35

  procedure P1 ( tablename in varchar2) is
  begin
       dbms_output.put_line ('Start');
       dbms_stats.gather_table_stats('PRD_1', tabname => tablename, estimate_percent =>100, method_opt => 'for all indexed columns size auto', degree => dbms_stats.default_degree ,cascade => true);
       dbms_output.put_line ('End');
  end;