Patent ID: 8452756
Filing Date: 2013-05-28
Classification: G06F

Abstract:
1. 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: 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.