Example of DBMS_STATS

BEGIN

      DBMS_STATS.GATHER_TABLE_STATS ( ownname => 'MYUSR',

                                      tabname => 'MY_PART_TABLE',

                                      estimate_percent =>1,

                                      method_opt =>'FOR ALL INDEXED COLUMNS SIZE 1',

                                      granularity =>'PARTITION',

                                      DEGREE=>8,

                                      NO_INVALIDATE => TRUE,

                                      Cascade => TRUE);

END;