Estadísticas usando DBMS_STATS

alter session set sort_area_size = 67108864;

BEGINSYS.DBMS_STATS.GATHER_SCHEMA_STATS (
OwnName => 'OWNER',
Granularity => 'ALL',
Options => 'GATHER',
Gather_Temp => TRUE,
Estimate_Percent => 53,
Block_sample => TRUE,
Degree => 6,
Cascade => TRUE,
No_Invalidate => TRUE);
END;
/