Support gather_plan_statistics

[Vladimir Sitniko]

Hi,

Currently SQL Developer does not support displaying detailed resource consumption of a particular query.

The long-available feature is described by Jonathan Lewis:http://jonathanlewis.wordpress.com/2007/11/25/gather_plan_statistics/

For me being a performance engineer this is a major drawback of using PL/SQL Developer. That is the reason I use SQL Developer and evangelize SQL Developer

Can you please implement the feature in PL/SQL Developer?

For instance, in plan window if query contains "gather_plan_statistics", execute a query, do FULL fetch, and display statistics (starts, actual rows, buffer gets, disk reads, temp usage, etc)

Note: ideally there should be a way to copy&paste the resulting statistics to attach the results to a ticket management system.

 

[Marco Kalter]

In PL/SQL Developer you can use the Statistics page of the SQL Window or Test Window. See also chapter 6.2 ("Automatic Statistics") and chapter 20.2 ("Preferences / Oracle Options") in the User's Guide.

 

[Vladimir Sitniko]

I do know and I appreciate Statistics page.
That is a very useful feature.

Statistics page just does not display _per plan line_ resource consumption.
Overal statistics is almost useless when you tune a query.