Patent ID: 8190579

Claim:
A method of monitoring internal activity within one or more databases comprising: tracking updates to one or more database segments in the one or more databases based on log record information associated with each of the databases, wherein the log record information identifies a type of update, a location of the update within the database and the database in which the update occurred; accessing the log record information using a portal to a logger component of the databases; generating metrics using the accessed log record information including fragmentation metrics and update metrics, wherein the fragmentation metrics include statistics of an extent of database fragmentation and the update metrics include statistics of an extent of changes to a database; storing the fragmentation metrics and the update metrics in a change map; analyzing the fragmentation metrics and the update metrics stored in the change map to determine database maintenance requirements by comparing the fragmentation metrics and the update metrics to pre-defined thresholds set in a trigger file to determine when to perform one or more database utilities; and publishing the database maintenance requirements based on analysis of the metrics.