How much time it take to:
Select * from result_table;

This will give you an indication how much time it take to move the data
to the client.

Adar Yechiel
Rechovot, Israel



Allen, Brandon wrote:

>Maybe it's taking 7 minutes to return the data to your client over the
>network if it's a lot of data and/or you have a slow network connection.
>How long does it take if you just spool the output to a file on the
>server (set term off)?
>
>Regards,
>Brandon Allen
>
>
>
--
http://www.freelists.org/webpage/oracle-l