"Alistair" <alistair.thomson_at_sphinxcst.co.uk> wrote in message news:<a2mljm$att$1_at_thorium.cix.co.uk>...
> Hi
>
> Redo log size and checkpoint interval will play a part. Have you also
> specified a decent buffer size?
>
> Alistair
>
> "Wood Butcher" <alu_at_dairynet.com> wrote in message
> news:c4A38.20635$Xs4.4352799_at_feed.centurytel.net...
> > Hi,
> >
> > What tricks can I do to improve "import" performance on an Oracle 8.1.7
> SID ??
> >
> > I want to decrease my import window.
> >
> > Thanks for any suggestions.
> >
> > Art
> >
You may need to shutdown your database and change these init.ora parameters
1)Increase sort_area_size significantly
2)increase log buffer
Give a large number to the buffer parameter in the parfile (like 10000000)
and turn off archiving
This has helped me considerably
Hope this helps you too
Michael Tubuo Ngong (DBA)
Received on Wed Jan 23 2002 - 12:30:05 CST
