Oracle International Corporation

Palash Sharma

Mohamed Ziauddin

Cetin Ozbutun

Sunil Parrokkaren Chakkappen

Zhan Li

Yiqiong Zhang

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.

Growing community of inventors

Belmont, CA, United States of America

Palash Sharma