The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 30, 2009
Filed:
Sep. 23, 2004
Vipul Manubhai Shah, Foster City, CA (US);
John Mark Beresniewicz, San Mateo, CA (US);
Nauman Ahmed Chaudhry, New Orleans, LA (US);
Kyle Hailey, San Francisco, CA (US);
Hui Lin, Sunnyvale, CA (US);
Hsiao-te Su, Milpitas, CA (US);
Vipul Manubhai Shah, Foster City, CA (US);
John Mark Beresniewicz, San Mateo, CA (US);
Nauman Ahmed Chaudhry, New Orleans, LA (US);
Kyle Hailey, San Francisco, CA (US);
Hui Lin, Sunnyvale, CA (US);
Hsiao-te Su, Milpitas, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
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.