Re: archive question --- too many archive logs generated during data load

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 16 Oct 2001 10:40:39 +0100
Message-ID: <3bcc00af$0$225$ed9e5944@reading.news.pipex.net>

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3bc8bd25$1_at_news.iprimus.com.au...
> Have you changed the table into which you are loading to be 'nologging'?
> And, having done that, are you running SQL Loader in direct path mode?

and Sybrand wrote similarly

However the original question says

> > Data is loaded into a table using PL/SQL. Approximately 1 million rows
> > are inserted.

Which does not necessarily imply the use of SQL*Loader at all. In which case the first recommendation would be to move to using sql*loader in the first place, and then to use direct path.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Oct 16 2001 - 04:40:39 CDT