Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CTAS question

Re: CTAS question

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 31 May 2006 20:11:58 +0800
Message-Id: <6.2.1.2.0.20060531200935.01fc6a10@pop.singnet.com.sg>

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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 31 2006 - 07:11:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US