Fetch speed in SQL Developer

From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Thu, 9 Mar 2017 16:06:57 +0100
Message-ID: <f3d8ac64-e945-4dbe-94a0-159d5d49b244_at_bluewin.ch>



Hi Jeff,

i know an application that fetches 80.000 - 100.000 rows. (Yeah, that does not make sense, it is OLTP).
SQL trace show that the db is waiting on sql net message from client between fetches.
(Don't anybody tell me that is an idle wait event, it is not in this case.) I suspect that the application is processing the rows and the db is waiting for it.
Now the application vendor has told my customer to fetch 100.000 rows in sql developer as for a test and indeed my client is waiting around 20 seconds,
fetching all rows using cntrl + PageDown. This seems actually too long. However I am not sure if that is a valid test for the network transfer rate or SQL Developer is taking a time toll fetching the rows.
Therefore I am asking. Tests on my laptop suggest it is really the network transfer that takes the time.
Since this is a question that might concern others as well I included the list.

Regards

Lothar

-- 




--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 09 2017 - 16:06:57 CET

Original text of this message