Publish pending stats - oracle database script

-- Publish Pending stats for table  EXEC DBMS_STATS.PUBLISH_PENDING_STATS ('SCHEMA_NAME,'TABLE_NAME');  -- Publish pending stats for a schema  exec dbms_stats.publish_pending_stats('SCHEMA_NAME',null);