Thanks, Stephane, for the plug. ;-)
The idea behind the paper was to show how to get data moved from one
database to another once the target schema was created. Some of it
addressed speeding up import: things you can do include setting the
target database to noarchivelog during the import, ensuring that your
redo logs are large and/or numerous enough to prevent log switches from
waiting on checkpoint creation, and, as you mentioned, setting
INDEXES=N.
Paul Baumgartel
Adept Computer Associates, Inc.
- Stephane Faroult <sfaroult_at_oriolecorp.com> wrote:
> Bill,
>
> Paul Baumgartel (also on this list) wrote a good paper some time
> ago on this topic. You may find it a http://www.oriole.com in the
> 'Library' section. The paper was written a couple of years ago but
> most if not all of the advice is still perfectly valid.
>
> >----- Original Message -----
> >From: "Magaliff, Bill" <Bill.Magaliff_at_lendware.com>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Wed, 20 Mar 2002 19:48:18
> >
> >i'm getting larger and larger db dumps from clients
> >that i need to import
> >into local db's . . . dump appoaching 3Gb (only the
> >one schem I need).
> >
> >Looking for ways to speed up import . . . tried
> >playing with buffer size and
> >commit=y, but not much luck. Also tried delaying
> >index creation,
> >which helps some . . .
> >
> >running 8.1.7.2 on solaris 8 - single cpu,
> >depending on the box anywhere
> >from 2 - 4 Gb RAM
> >
> >Thanks, all
> >
> >Bill Magaliff
> >Framework, Inc.
> >914-631-2322
> >
> Stephane Faroult
> Oriole Corporation
> Performance Tools & Free Scripts
> --------------------------------------------------------------
> http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> --------------------------------------------------------------
>
> --
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: treegarden_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Mar 21 2002 - 10:14:08 CST
