公开(公告)号：US11907218B1

公开(公告)日：2024-02-20

申请号：US17886804

申请日：2022-08-12

Applicant: Oracle International Corporation

Inventor： Sunil P. Chakkappen ,  Mohamed Ziauddin ,  Cetin Ozbutun ,  Palash Sharma ,  Yiqiong Zhang ,  Zhan Li

IPC: G06F16/2453 ,  G06F16/958

CPC classification number: G06F16/24542 ,  G06F16/972

Abstract: Techniques for automatically preventing execution plan regressions are provided. In one technique, in a first user database session, in response to receiving a first database statement, a first execution plan is generated and, while executing the first execution plan, first performance data that indicates one or more first performance metrics of executing the first execution plan is recorded. In response to receiving a second database statement, where the first execution plan may be used to generate a result for the second database statement, a second execution plan is generated and second performance data that indicates one or more second performance metrics of executing the second execution plan is recorded. A comparison between the first performance data and the second performance data is performed. Based on the comparison, it is determined whether the second execution plan will be stored for future use to process a database statement.

公开(公告)号：US20240054127A1

公开(公告)日：2024-02-15

申请号：US17886804

申请日：2022-08-12

Applicant: Oracle International Corporation

Inventor： Sunil P. Chakkappen ,  Mohamed Ziauddin ,  Cetin Ozbutun ,  Palash Sharma ,  Yiqiong Zhang ,  Zhan Li

IPC: G06F16/2453 ,  G06F16/958

CPC classification number: G06F16/24542 ,  G06F16/972

Abstract: Techniques for automatically preventing execution plan regressions are provided. In one technique, in a first user database session, in response to receiving a first database statement, a first execution plan is generated and, while executing the first execution plan, first performance data that indicates one or more first performance metrics of executing the first execution plan is recorded. In response to receiving a second database statement, where the first execution plan may be used to generate a result for the second database statement, a second execution plan is generated and second performance data that indicates one or more second performance metrics of executing the second execution plan is recorded. A comparison between the first performance data and the second performance data is performed. Based on the comparison, it is determined whether the second execution plan will be stored for future use to process a database statement.

公开(公告)号：US11068460B2

公开(公告)日：2021-07-20

申请号：US16248479

申请日：2019-01-15

Applicant: Oracle International Corporation

Inventor： Mohamed Zait ,  Sunil Chakkappen ,  Christoforus Widodo ,  Zhan Li

IPC: G06F16/00 ,  G06F16/22

Abstract: Automated Index Management entails automated monitoring of query workload in a DBMS to determine a set of higher load queries to use to evaluate new potential indexes. Without the need of user approval or action, the potential indexes are automatically created, evaluated and tested, and then made available for system wide use for executing queries issued by end users. Indexes created by Automated Index Management are referred to herein as auto indexes.

公开(公告)号：US20210303539A1

公开(公告)日：2021-09-30

申请号：US17343659

申请日：2021-06-09

Applicant: Oracle International Corporation

Inventor： Mohamed Zait ,  Sunil Chakkappen ,  Christoforus Widodo ,  Zhan Li

IPC: G06F16/22

Abstract: Automated Index Management entails automated monitoring of query workload in a DBMS to determine a set of higher load queries to use to evaluate new potential indexes. Without the need of user approval or action, the potential indexes are automatically created, evaluated and tested, and then made available for system wide use for executing queries issued by end users. Indexes created by Automated Index Management are referred to herein as auto indexes.