Method for Analyzing Performance Data for a Database

Abstract

Computer implemented software uses multi-dimension analysis to identify performance issues, locate the root cause(s) of performance problems, and may also serve other purposes such as workload management, capacity planning In especially preferred embodiments, there can be three, four or even more dimensions being analyzed. Useful dimensions are contemplated to include database call, execution path, process status, target, and application that generates database calls. In the specific world of Oracle databases, the database call is a SQL statement, the execute path is a SQL plan, the process status is an event, the target is a database object or a database file, and the application that generates database calls is a session, or user, or service, or module, or machine. Primary and secondary attributes of dimensions can be used to facilitate analysis. GUIs can advantageously present data in matrix format that facilitates dimension picking.

Dependencies are inferred from the claim text.