don't mess with this setting
for 99% of the users and circumstances out there, leaving it at the default is good
if you set the array fetch size to 1 and have 124 rows, we're gonna make 124 round trips to get your data
sqlplus uses OCI, sql developer uses JDBC
are you upset SQL Developer is too fast?
Sorry for the late reply and hanks for the feedback. It was confusing to the staff why it was taking 6 seconds on DB server and app server but results were returned less than a second using SQL developer. However, we discovered that developer was only returning partial results, scrolling down the output window would bring back the remaing items in the same 6 seconds.