Re: Speeding up an unload

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 23 Feb 2002 08:04:08 -0800
Message-ID: <a58eho0sc8@drn.newsguy.com>

In article <wZBd8.171704$Re2.12863306_at_bin6.nnrp.aus1.giganews.com>, "Gary" says...
>
>Sorry, knew I wanted to say more...
>
>I am just doing a select * from a table.
>

make sure you are array fetching.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:459020243348

for an example in Pro*C that takes a query as input and dumps it to stdout. You pass in the array size as well to tell it how many rows to fetch on each fetch.

>"Gary" <garychars_at_yahoo.com> wrote in message
>news:1Whd8.149077$Re2.11835689_at_bin6.nnrp.aus1.giganews.com...
>> I need to extract data from the DB to a flat file(non-export format), but
>> the extracts take forever-close to an hour for 2.1Gig. Does anyone know
>of
>> a way to extract data faster?? Are there any performance tips I should
>> know? How long should something like this take?? Thanks a bunch!!
>>
>> Gary
>>
>>
>>
>>
>>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sat Feb 23 2002 - 10:04:08 CST