Gather stats for schema - oracle database script

BEGIN dbms_stats.gather_schema_stats( ownname => 'SCOTT', --- schema name   options => 'GATHER AUTO',  estimate_percent => dbms_stats.auto_sample_size,   method_opt => 'for all columns size repeat',  degree => 24  ); END; /