Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
A newer execution plan than the one you are viewing was collected for the statement during the selected time frame, or during a later time frame.
| Newer execution plan exists |
| Description | |
| What to do next | Perform one of the following options: n Expand the time frame you are viewing, using the time frame list box, to identify the new execution plan. Expand the time frame until it includes the current time so that the newer execution plan is loaded. n Examine the different execution plans that were captured, and their real resource consumption. |
| Advice | Try to identify the source of the different execution plans. To resolve the multiple plans, consider the following solutions: n In the All Changes section view, observe whether any changes took place (such as schema or statistics changes). n In the Activity workspace, observe whether the execution plan is being run by different programs. |
No comments:
Post a Comment