Search notes:

Oracle: Statistics gathering

There are several methods to gather optimizer statistics:

Automatic
Manual
Online
Real-time
High frequency autoomatic

See also

The gather* procedures of the dbms_stats package.

The gather_plan_statistics hint.

sys.col_usage$