This content has been marked as final. Show 10 replies
Click on the sql you want to run in the worksheet and hit F6 or click the plan button in the toolbar
the explain plan tab is brought to the front automatically.
Would that be the same if I execute a SQL statement using the F9 key?
no, you get the result of the statement if you hit F9. F6 gives you the execution plan of your statement
Sorry, I misunderstood your first response - was thinking F6 same as F5 in TOAD.
What I am getting at is, I assume that hitting F6 gives the explain plan as Raptor believes it would use, where the script running now, but what I wanted was similar to the explain plan in a tkprof file, i.e. that was actually used, or being used, by a running piece of SQL.
Thanks again for feedback.
thats slated for the next release. Anything to do with tuning is being positioned for that and tkprof is one of them
I hope that will include some drill-down explains, e.g.
Reports tab -> DataDict reports -> DB Admin -> Top SQL -> (any report), click on a SQL statement and get explain plans and/or other drill-down options like those in OEM Top Sessions etc.
I also hope that future enhancements to explain plan will include the precious informations that
select plan_table_output from table(dbms_xplan.display('plan_table',null,'serial'))returns... in particular predicate information.
This is a must when investigating query performance.
Barry, or anyone else that might know,
Ahh,Has any progress been made on inclusion of the tkprof feature into SQL Developer?
thats slated for the next release. Anything to do
with tuning is being positioned for that and tkprof
is one of them
Performance and tuning is the next theme that we are working on and yes, tkprof is one on that list for inclusion