Solution: recreate plan_table, SQLgt; droptablePLAN_TABLE; SQLgt ;@? After rdbmsadminutlxplan is completed, the problem is solved.
Solution: recreate plan_table, SQLgt; drop table PLAN_TABLE; SQLgt ;@? /Rdbms/admin/utlxplan
The generated environment is different from the actual environment execution plan, so the real environment does not go through the index. The test environment takes several seconds and the real environment lasts for more than two minutes.
Plan directly first
[SQL]
Please note this-'Plan _ table' is old versionWhat does Shenma mean?
Cause: toad execution plan analysis was used, so it executes the plan_table generated by its own script.
Solution: recreate plan_table,
SQL> drop table PLAN_TABLE;
SQL> @? /Rdbms/admin/utlxplan
After this is done, the problem is solved, but I don't know the details. Well, if you don't go through the index, you can check it.10053Event.10053Next event supplement
But can't toad be used at will? No. The toad execution plan can be used.TOAD_PLAN_TABLETo store it!
Finished.