pl/sql developer freezing (applications not responding) when trying stop event monitor

[stigus]

The essence of the problem described in the title. When you try to stop Event Monitor running 20 minutes or more (perhaps the problem lies in something else, but it happens in long-term processes), the application hangs (application not responding). Fictional example to simulate the situation, I enclose:

declare
   lPipeName                varchar2 (17) := 'Test:MonitorEvent';
   lStepCount               pls_integer := 1200;
   lPipeStatus              pls_integer;
   lSendMessageStatus       pls_integer;
begin

   lPipeStatus := dbms_pipe.create_pipe (
      PipeName => lPipeName,
      Private  => false
   );

   for rMessage in (
      select level as step
        from dual
     connect by level <= lStepCount
   ) loop

      dbms_pipe.reset_buffer ();
      dbms_pipe.pack_message (rMessage.Step);
      lSendMessageStatus := dbms_pipe.send_message (PipeName => lPipeName);

      if mod (rMessage.Step, 10) = 0 then
         dbms_pipe.pack_message ('Processed: ' || rMessage.Step || '/' || lStepCount);
         lSendMessageStatus := dbms_pipe.send_message (PipeName => lPipeName);
      end if;

      dbms_lock.sleep (1);
   end loop;

   dbms_output.put_line (dbms_pipe.remove_pipe (lPipeName));

exception
   when others then
      dbms_output.put_line (dbms_pipe.remove_pipe (lPipeName));
end;

I use:
Windows 10 version 1607 build 14393.693
PL/SQL Developer version 10.0.5.1710
Oracle DB version 11.2.0.3.0

Event Monitor a great tool we use it as a debugger in a long process and I would not like to abandon it.

Thanks!

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[stigus]

Done! Check your email!