I notice that you automatically retrieve any dbms_output, and there is no option to either disable, or to set any sort of limit.
I'm uneasy about this..
I just killed a long-running block, and a while after that I was presented with 1.8M rows of output..
Moving cursor away from that statement and then back, took ~20s just to redisplay the 1.8M rows of output
So, it looks like you're reading the output *way* faster than pl/sql developer ever did, but there are still cases where some routine will produce way more output than is sensible to retrieve.So, maybe you should retrieve and display in chunks, and give me a way to stop it, and/or allow me to set some limits.
Maybe also displaying something like "Completed in X seconds. Fetching XXX lines of output"
Just a quick test:
begin
for i in 1..100000 loop
null;
dbms_output.put_line('Line ' || i);
end loop;
end;
/
This took 16s to return and display the 100K rows of output, but says "PL/SQL procedure successfully completed in 0,16s"