I Iain Member Feb 17, 2012 #1 I've got a weird one in PL/SQL Dev 9. When I do an explain plan (F5) on a query, there are no results in the plan table. This works fine in PL/SQL Dev 8. Same query, same database. Any ideas? Iain
I've got a weird one in PL/SQL Dev 9. When I do an explain plan (F5) on a query, there are no results in the plan table. This works fine in PL/SQL Dev 8. Same query, same database. Any ideas? Iain
Marco Kalter Administrator Staff member Feb 17, 2012 #1 After the query plan is retrieved, the results will be deleted from the plan_table. I thought this was the same in 8.0, but I'm not sure.
After the query plan is retrieved, the results will be deleted from the plan_table. I thought this was the same in 8.0, but I'm not sure.
I Iain Member Feb 17, 2012 #1 How do I get them to stick around long enough for them to be viewed in the grid under the query being explained? Iain
How do I get them to stick around long enough for them to be viewed in the grid under the query being explained? Iain
I Iain Member Feb 17, 2012 #1 No worries. It decided to start working again. I think it was something to do with the Selected User not being the Current User, because this was all I changed to get it working. Iain
No worries. It decided to start working again. I think it was something to do with the Selected User not being the Current User, because this was all I changed to get it working. Iain
