Invention Grant
- Patent Title: Multi-database, runtime database query performance monitoring
- Patent Title (中): 多数据库,运行时数据库查询性能监控
-
Application No.: US12240814Application Date: 2008-09-29
-
Publication No.: US08700602B2Publication Date: 2014-04-15
- Inventor: Lawrence E. Schapker , Jayagopal Theranikal
- Applicant: Lawrence E. Schapker , Jayagopal Theranikal
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Marger Johnson & McCollom PC
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F7/00

Abstract:
A method to monitor database performance includes gathering information from a remote, monitored database related to the monitored database performance during a predetermined time, collecting statistics corresponding to any queries executed during the predetermined time, testing at least one rule against the statistics corresponding to each query, and if the testing results in a rule violation, identifying the query that caused the rule violation. A method to monitor database performance includes gathering statistics related to execution of a query statement, comparing at least one of the statistics against at least one rule to determine if the statistics violates a threshold established by the rule, if the statistic violates the threshold, identifying the query statement as a violating query statement, and repeating the comparing and identifying until all rules have been compared. A system has a local repository and a rules engine to gather information from at least one remote, monitored database, locate query statement executions in the information and to collect statistics with regard to the query execution, and test at least one rule against the statistics to determine if the query statement violates the rule.
Public/Granted literature
- US20100082517A1 MULTI-DATABASE, RUNTIME DATABASE QUERY PERFORMANCE MONITORING Public/Granted day:2010-04-01
Information query