公开(公告)号：US20250094421A1

公开(公告)日：2025-03-20

申请号：US18595820

申请日：2024-03-05

Applicant: Oracle International Corporation

Inventor： Prabhaker Gongloor ,  Shantanu Joshi ,  Mughees A. Minhas ,  Karl Dias ,  Sriram Vrinda ,  John M. Beresniewicz ,  Daniel S. Tow ,  Girish Kumar Balachandran

IPC: G06F16/2453

Abstract: Techniques for generating recommendations based on the predicted performance of an execution plan are disclosed. A system predicts the future characteristics of a set of data objects associated with a set of structured query language (SQL) statements. The system predicts how the changes to the set of data objects will result in changes to a query execution plan associated with the SQL statements. The system predicts a set of performance metrics for the changed query execution plan. Based on the predicted performance, the system generates recommendations for modifying data, applications, or database server operations to improve performance.