Script to analyze table subpartitions

This script will analyze specified subpartitions in a loop, useful when some partitions /
subpartitions in the table have been modified or re-built.

BEGIN
  FOR rec IN
    (SELECT subpartition_name
     FROM all_tab_subpartitions
     WHERE table_owner = 'SCHEMA_OWNER'
     AND table_name = 'TABLE_NAME'
         AND partition_name in ('SUBPART1', 'SUBPART2', 'SUBPART3'))
   LOOP
     SYS.DBMS_STATS.GATHER_TABLE_STATS(
             OwnName          => 'SCHEMA_OWNER',
             TabName          => 'TABLE_NAME',
             PartName         => rec.subpartition_name,
             Granularity      => 'SUBPARTITION',
             Estimate_Percent => 10,
             Degree           => NULL,
             Cascade          => TRUE);
   END LOOP;
END;
/