Why there is the difference in Oracle PL/SQL response time within SQL Developer vs. SQL Plus?

Question

I have PL/SQL function that returns cursor that holds 28 columns and 8100 rows. When I execute that function from SQL Plus I got the results right away and in SQL Developer I'm running script that takes looong time (about 80 seconds). The same happen from Java code. When number of columns reduced to 2 then I got response in less than 4 seconds. Can someone explain what is going on in this case?

Answer 1

The easiest experiment to make is changing the "SQL Array Fetch Size" in SQL Developer, which defaults to 50. If you see results from bumping it to 500, there's the answer.

Interestingly, the default for the equivalent SQL*Plus parameter is only 15, but as APC said, SQL*Plus has the advantage of being native.

If changing "SQL Array Fetch Size" does not do anything, the next thing to look at is JDBC settings, which SQL Developer uses and SQL*Plus does not.