The proper way to analyze tables (Collect Statistics) in Oracle 10g and 11g.

Before Oracle 10g, people usually use “analyze table” command to collect statistics. Follow the command below if you need to collect statistics after Oracle 10g.