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