发明授权
- 专利标题： Diagnosing database performance problems using a plurality of wait classes
- 专利标题（中）： 使用多个等待类来诊断数据库性能问题
-
申请号： US10950023申请日： 2004-09-23
-
公开(公告)号： US07555499B2公开(公告)日： 2009-06-30
- 发明人: Vipul Manubhai Shah , John Mark Beresniewicz , Nauman Ahmed Chaudhry , Kyle Hailey , Hui Lin , Hsiao-te Su
- 申请人： Vipul Manubhai Shah , John Mark Beresniewicz , Nauman Ahmed Chaudhry , Kyle Hailey , Hui Lin , Hsiao-te Su
- 申请人地址： US CA Redwood Shores
- 专利权人： Oracle International Corporation
- 当前专利权人： Oracle International Corporation
- 当前专利权人地址： US CA Redwood Shores
- 代理机构： Hickman Palermo Truong & Becker LLP
- 主分类号： G06F7/00
- IPC分类号： G06F7/00 ; G06F17/00 ; G06F12/00 ; G06F17/30 ; G06F11/00
摘要：
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.
公开/授权文献
信息查询
