Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-09-23
2009-06-30
Rones, Charles (Department: 2164)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C714S001000, C714S002000, C714S015000, C714S025000, C714S038110, C714S039000, C714S042000, C714S043000, C714S047300, C714S048000, C714S056000
Reexamination Certificate
active
07555499
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.
REFERENCES:
patent: 5526480 (1996-06-01), Gibson
patent: 6311327 (2001-10-01), O'Brien et al.
patent: 6901582 (2005-05-01), Harrison
patent: 6985901 (2006-01-01), Sachse et al.
patent: 7089260 (2006-08-01), Arnold et al.
patent: 2002/0049687 (2002-04-01), Helsper et al.
patent: 2005/0086246 (2005-04-01), Wood et al.
patent: 2005/0210056 (2005-09-01), Pomerantz et al.
“Benefits of Veritas Indepth for Oracle within an Operational Environment” retrieved on Jan. 16, 2007 from: http://www.dlt.com/storage/PDF/whitepapers/veritas/apm/Indepth-Oracle-Whitepaper.pdf.
“Veritas Database Performance Solutions” retrieved on Jan. 16, 2007 from: http://eval.veritas.com/mktginfo/es/mx/enterprise/white—papers/performance—solutions.pdf.
pages 3-2, 3-3, 3-4, 3-11, 14-28, 15-10, 16-8, 21-15, 22-12, 22-13, 22-24, and 22-25 from: http://web.archive.org/web/20040808221329/http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96533.pdf (archived Aug. 8, 2004) (published Mar. 2002).
pages 22-9, 22-26, 22-27, 22-37, 22-39, 22-51 from: http://web.archive.org/web/20040808221329/http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96533.pdf (archived Aug. 8, 2004) (published Mar. 2002).
pages 22-9, 22-26, 22-27, 22-37, 22-39, 22-51, 23-6, 24-1, 24-2, 24-3, 24-6, 24-9, 24-16, 24-17, 24-20, and 24-68 from: http://web.archive.org/web/20040808221329/http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96533.pdf (archived Aug. 8, 2004) (published Mar. 2002).
Veritas Datasheet, Veritas Indepth™ for Oracle, undated, 4 pages.
Veritas Datasheet, Veritas Indepth™ for Oracle, undated, 4 pages, (2003).
Beresniewicz John Mark
Chaudhry Nauman Ahmed
Hailey Kyle
Lin Hui
Shah Vipul Manubhai
Hickman Palermo & Truong & Becker LLP
Hotelling Harold A
Oracle International Corporation
Rones Charles
LandOfFree
Diagnosing database performance problems using a plurality... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Diagnosing database performance problems using a plurality..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Diagnosing database performance problems using a plurality... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4136266