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_statsschema_owner
See the Oracle documentation for full details of how and when to run it.