Invention Grant
- Patent Title: Predicting and halting runaway queries
-
Application No.: US16903157Application Date: 2020-06-16
-
Publication No.: US11556539B2Publication Date: 2023-01-17
- Inventor: Pallab Rath , Hozefa Yusuf Palitanawala , Vijay Simha Joshi
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Invoke
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/2453 ; G06F11/34 ; G06F9/50 ; G06F16/22

Abstract:
Operations include halting a runaway query in response to determining that a performance metric of the query exceeds a performance threshold. The runaway query halting system receives a query execution plan associated with a query and divides the received execution plan into one or more components. For each component, the system determines a predicted resource usage associated with executing the component. The system further determines a predicted resource usage associated with the query execution plan based on the predicted resource usage associated with each component. The system executes the query associated with the received query execution plan and compares the predicted resource usage associated with the query to a resource usage threshold. In response to determining that the predicted resource usage of the query execution plan exceeds the resource usage threshold, the system halts execution of the query associated with the query execution plan.
Public/Granted literature
- US20210081409A1 PREDICTING AND HALTING RUNAWAY QUERIES Public/Granted day:2021-03-18
Information query