优化案例--重建索引引发的sql性能问题（Optimization case - SQL performance issues raised by reconstructing indexes）.docVIP

优化案例--重建索引引发的sql性能问题（Optimization case - SQL performance issues raised by reconstructing indexes） Optimization case - SQL performance issues raised by reconstructing indexes Personal classification: trouble shooting On Monday, developers reported that a job ran for a full day on Saturday, but it was back to normal on Sunday and asked to find out why Start by generating the AWR report on Saturday and view the SQL section The execution of the second highest SQL in buffer gets is found to be 0, and the developer confirms that it is the stored procedure Check the stored procedure pkd_justin.pro_ex