DBMS_STATS

execute DBMS_STATS.gather_table_stats(ownname => 'x', tabname => 'x', estimate_percent => NULL,degree =>DBMS_STATS.AUTO_DEGREE, cascade => TRUE, no_invalidate => TRUE);

execute DBMS_STATS.gather_schema_stats(ownname => 'x',estimate_percent => NULL,degree => DBMS_STATS.AUTO_DEGREE,cascade => true,no_invalidate => TRUE);

execute DBMS_STATS.gather_database_stats(estimate_percent => NULL,degree =>DBMS_STATS.AUTO_DEGREE,cascade => true,no_invalidate => TRUE);