Re: CTAS question
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: sat0789@xxxxxxxxxxx
- Date: Wed, 31 May 2006 20:11:58 +0800
If using an SQLPlus client to "time" the performance, even such a simple
thing
as SET ARRAYSIZE can make a big difference when you get to 100s and 1000s
of records being retrieved by the client.
If you SPOOL , that also adds to the total time on the client.
Also SET TERMOUNT OFF/ON makes a difference.
Hemant
At 04:39 PM Wednesday, Yechiel Adar wrote:
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
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l
Other related posts:
