Maintaining the Oracle database
Like DB2, Oracle has
a routine that regularly maintains the database. Similarly, this too
can be run manually. The tool is invoked as follows:
dbms_stats.gather_schema_stats<schema_owner>