Hewlett-Packard Development Company, L.p.

Oracle International Corporation

Avi Huber

Brent Arthur Enck

Michael Haeuptle

Rupesh Kumar

Constantinos Papadopoulos

Mark Sturdevant

Techniques for capturing query execution statistics are disclosed. The disclosed system determines which queries are executing during a sampling interval. The system identifies related queries that share similarity criteria with the currently executing query. The system obtains query execution statistics for the query executing during the sampling interval and any related queries. The system generates or obtains statistics during a monitoring window that spans a longer period of time than a single intervening period between the current sampling interval and a prior interval. The statistics are stored in permanent storage or transmitted to a requesting computer. The system refrains from analyzing statistics for queries (and any related queries) that did not execute during a current sampling interval.

Capturing query execution statistics

A method for measuring business transaction performance, includes the steps of, at a top-level component, assigning a correlation tag and original time stamp to a server request, passing the original time stamp with any server requests from the top-level component to one or more subsequent components, and computing an aggregate latency over a predetermined interval at the top-level component and at each subsequent component based on the original time stamp.

Method and apparatus for measuring business transaction performance

Growing community of inventors

Los Altos, CA, United States of America

Avi Huber