SQL Text from Tools/Sessions to explain plan

[Thijs Blaauw]

The current Tools/Sessions window is a great tool to find which statements are taking a long time to run. If it were possible to copy the statement on the SQL text tab directly into an Explain Plan window you also could see why.

I know that it is possible to copy the statement lines from the SQL Text tab, but they are randomly chopped off, often in the middle of keywords, so they need editing before you can run explain plan.

Copying to the Explain Plan window could consist of pasting all the lines together, putting the result through the Beautifier, and showing the beautified result in the Explain Plan window.

I would really like to see this functionality in a next version. In 6.0 maybe ;-)?

Regards,
Thijs Blaauw

 

[Marco Kalter]

This is on the list of enhancement requests. Right now you can use this solution .

 

[Thijs Blaauw]

I see I am not very original

Thank you for pointing out the existing solution. It is an improvement.

Is the list of enhancements requests available to us, so I can check if a feature is already requested, before asking for it?

Or is the priority of a request based on the number of people asking for it?

Regards,
Thijs Blaauw

 

[aotte]

If you are looking for the Explain plan, take a look at this thread.

It is Chris' excellent Session SQL which shows you the plan of SQL of the session you are looking at...