Re: Slow Oracle 8.0.5 Unloads

Chris,

A number of things come to mind,

1. Are you using a RAID array configured with 100% write back cache ?
2. Do you use PQO in your select statement in the extraction? (explain plan please)
3. How do you unload ? PRO*C, SQL,...

Chris.

pimpwillow_at_my-deja.com wrote:
>
> We are running the standard version of Oracle 8.0.5.2.1. We have one
> database which we unload, massage the data a bit, and then load a
> slightly smaller number of rows into a second DSS database for data
> mining. We unload about 30 million rows and load about 22 million
> daily.
>
> The unload takes longer than the direct path load (not parallel loads
> because we don't have the enterprise server). The unload takes 6 hours,
> the load 4 hours. These are done in sequence on the same 4-cpu Sun
> machine.
>
> Anyone know why the unload would take longer than the load, which has to
> rebuild some pretty chunky indexes?
>
> Is there anything that we can do to enhance the performance of these
> unloads? Loads?
>
> Thanks,
> Chris
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 24 2000 - 16:43:16 CST