Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Array Fetch Size and fast results

user9327139Jul 17 2015 — edited Sep 23 2015

If I set SQL Array Fetch Size to match the number of rows returned it return all 124 rows in less than a second. If I set the SQL Array Fetch Size to 1 more than the rows returned it takes 6 seconds to return the results.. I can run the same query directly on the DB server using SQL Plus and it too takes 6 seconds. Why does developer return my exact rows so fast

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2015
Added on Jul 17 2015
2 comments
732 views