Oracle database execution plan anomaly detection method

An Oracle database execution plan anomaly detection method comprises the following steps of: S1, analyzing and concluding execution plan anomaly data, and constructing a database execution plan healthassessment model; S2, determining each preset threshold parameter in the model, initializing error times, inputting a current business scene and database performance parameters, and calculating a current health value; S3, if the current health value is smaller than or equal to a preset minimum health value, adding 1 to the error times, and if the current health value is larger than the preset minimum health value, determining that the current execution is correct; and S4, when a cumulative value of the error times is greater than a preset threshold, indicating that the execution plan is abnormal, and transmitting alarm information or executing a repair script. According to the Oracle database execution plan anomaly detection method, the system performance after the database execution planis abnormal is concluded