A system and method for automated database management are provided.
Statistics relating to operation of a database may be collected, wherein
the database comprises one or more database objects. Characteristics of
the database objects may be determined, either automatically or by user
intervention, using the collected statistics, one or more policies,
and/or one or more definitions. The policies and definitions may be
defaults or may be customized by a user. Actions to be performed on the
database objects may be determined, either automatically or by user
intervention, based on the characteristics of the database objects. A
schedule for performing the actions on the database objects may be
automatically determined. The actions may be performed on the database
objects based on the schedule. The actions on the database objects may be
confirmed. The results of the actions on the database objects may be
analyzed or monitored. Policies and/or definitions may be reconfigured
based on the results. The system and method may automatically decide to
perform one or more REORG actions on the database objects based on the
statistics. A recommendation of a modification to one or more of the
database objects may be generated based on the statistics. The scheduled
actions may be modified as a result of detecting a change in the
characteristics or usage of at least one of the database objects.