Patent ID: 8452756

Claim:
An apparatus comprising: at least one processor; a memory coupled to the at least one processor; an access plan cache residing in the memory that includes a plurality of entries that each comprises a query statement and corresponding execution detail for the query statement that includes data collected from a plurality of previous executions of the query, wherein the execution detail for a corresponding query statement includes: timestamp of last execution of the query statement; most expensive execution of the query statement; total processing time of the query statement; total number of times the query statement was executed; user name that executed the query statement; job name that executed the query statement; job user that executed the query statement; and job number that executed the query statement; an access plan storage mechanism that stores the plurality of entries in the access plan cache; a performance analysis mechanism that analyzes the plurality of entries in the access plan cache and provides a graphical user interface that allows a user to select and filter the execution detail stored in the access plan cache for display in the graphical user interface; and an autonomic snapshot mechanism that autonomically takes periodic snapshots of the access plan cache at time intervals specified in a user-defined snapshot criteria, wherein the autonomic snapshot mechanism autonomically compares two snapshots and notifies a user if a change between the two snapshots exceeds a specified threshold.