This content has been marked as final. Show 2 replies
Instead of doing Save Grid as Report from Tools -> Monitor Sessions into your User Defined Reports, instead copy the Sessions report from Data Dictionary Reports -> Database Administration -> Sessions -> Sessions
You will notice that UserReports.xml in C:\Users\<username>\AppData\Roaming\SQL Developer will have a line near the bottom containing the Action information for Trace Session and Kill Session. Just edit that section of UserReports.xml to include similar information for a Stop Trace action, specifically with this statement:
For most users, either disconnecting the session or using Kill Session is sufficient, but learning a new trick hurts no one.
<![CDATA[begin dbms_monitor.session_trace_disable(#SID#, #SERIAL#); end;]]>
SQL Developer Team
Thanks for your answer.
Just one remark: such a report with additional item s must not be edited with the reports editor from SQL Developer any more. Saving the report out of the editor would delete the items.
My version is Version 3.2.10.09
Edited by: glauser on 14.11.2012 06:55