Invention Grant
- Patent Title: Method and mechanism for out-of-the-box real-time SQL monitoring
- Patent Title (中): 开箱即用的实时SQL监控的方法和机制
-
Application No.: US12060117Application Date: 2008-03-31
-
Publication No.: US08577871B2Publication Date: 2013-11-05
- Inventor: Benoit Dageville , Venkateshwaran Venkataramani
- Applicant: Benoit Dageville , Venkateshwaran Venkataramani
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F17/00
- IPC: G06F17/00

Abstract:
Methods, systems, and computer program products for monitoring database queries and executions is disclosed. The query syntax may conform to the structured query language (SQL). The approach supports various performance statistics to be monitored at each step of the query statement's execution plan and for each row processed in order to meet requirements of a near real-time query monitoring solution. Such statistics include timing information plus some miscellaneous statistics like the number of rows processed, the amount of memory used, the amount of data spilled to disk, etc.
Public/Granted literature
- US20090248621A1 METHOD AND MECHANISM FOR OUT-OF-THE-BOX REAL-TIME SQL MONITORING Public/Granted day:2009-10-01
Information query