dbms_stats.gather_table_stats(ownname => user, tabname => v_table , estimate_percent => 100, 
method_opt => 'for all indexed columns size auto',
degree => 4 ,cascade => v_cascade );

dbms_stats.gather_table_stats(ownname => user, tabname => 'MYTAB' , estimate_percent => 100, method_opt => 'for all indexed columns size auto');

analyze table MYTAB estimate statistics sample 100 percent for table for all indexed columns

sql> analyze table emp estimate statistics sample 100 percent for table for all indexed columns for all indexes

scott@9i >  analyze table emp estimate statistics sample 100 percent for table for all indexed columns;

Table analyzed.

scott@9i > exec dbms_stats.gather_table_stats('SCOTT','ANOTHER_EMP',ESTIMATE_PERCENT=>100,METHOD_OPT=>'for all indexed columns size auto',CASCADE=>True);

PL/SQL procedure successfully completed

scott@9i > select table_name,column_name,num_distinct,last_analyzed,num_buckets from user_tab_cols where table_name like ('%EMP%');

TABLE_NAME                     COLUMN_NAME                    NUM_DISTINCT LAST_ANAL NUM_BUCKETS
------------------------------ ------------------------------ ------------ --------- -----------
ANOTHER_EMP                    EMPNO                                    14 04-APR-06           1
ANOTHER_EMP                    ENAME
ANOTHER_EMP                    JOB                                       5 04-APR-06           1
ANOTHER_EMP                    MGR
ANOTHER_EMP                    HIREDATE
ANOTHER_EMP                    SAL
ANOTHER_EMP                    COMM
ANOTHER_EMP                    DEPTNO
EMP                            EMPNO                                    14 04-APR-06          13
EMP                            ENAME
EMP                            JOB                                       5 04-APR-06           4
EMP                            MGR
EMP                            HIREDATE
EMP                            SAL
EMP                            COMM
EMP                            DEPTNO

16 rows selected.

scott@9i > select table_name,index_name,num_rows,last_analyzed from user_indexes;

TABLE_NAME                     INDEX_NAME                       NUM_ROWS LAST_ANAL
------------------------------ ------------------------------ ---------- ---------
ANOTHER_EMP                    ANOTHER_EMP_EMPNO                  458752 04-APR-06
ANOTHER_EMP                    ANOTHER_EMP_JOB                    458296 04-APR-06
EMP                            EMP_EMPNO
EMP                            EMP_JOB