Oracle International Corporation

Rupesh Kumar

Avi Huber

Sean Joseph Connolly

Techniques for managing dataset resource instance performance via a data-centric approach are disclosed. A system determines an aggregated level of service demands placed on individual dataset resource instances that may be in a distributed computing system. The system may identify portions of a dataset that are associated with high levels of service demands. Once identified, the system may provide an administrator with the service demand information. The administrator may relocate these high demand dataset portions to other dataset resource instances that are better able to respond to the high levels of demand without impaired performance.

Analyzing performance of resource systems that process requests for particular datasets

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.

Growing community of inventors

Redwood Shores, CA, United States of America

Rupesh Kumar