Oracle International Corporation

Hsiao-te Su

Benoit Dageville

Tirthankar Lahiri

Karl Dias

Mohamed Ziauddin

Gary C Ngai

Mark Charles Ramacher

Alex Tsukerman

Vasudha Krishnaswamy

Sujatha Muthulingam

Graham Wood

Gianfranco Putzolu

John Mark Beresniewicz

Leng Leng Tan

Wanli Yang

Sushil Kumar

Richard Sarwal

Vishwanath Karra

Vipul Manubhai Shah

Hui Lin

Francisco Sanchez

Nauman Ahmed Chaudhry

Kyle Hailey

A method and apparatus for diagnosing database performance problems using a plurality of wait classes is provided. A set of statistical data that describes current activity within a database system is periodically retrieved. The set of statistical data may include information about the current activity of each user session connected to the database system. Thereafter, a set of cumulative statistical data that describes activity in the database system over a period of time is updated to reflect the retrieved set of statistical data. The set of cumulative statistical data includes statistics associated with each of a plurality of wait classes. A graphical user interface that displays the set of cumulative statistical data may be presented to a user. The graphical user interface allows the user to quickly ascertain the nature of the database performance problems by providing a view of the set of cumulative statistical data.

Diagnosing database performance problems using a plurality of wait classes

An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

Self-managing database architecture

Growing community of inventors

Milpitas, CA, United States of America

Hsiao-te Su