RE: would imp speed affect by setting indexes to NOLOGGING?

Everything in the schema on Server B is dropped before import, so I have an empty schema to begin with. I am not sure I understand what you meant by "dropping the indexes before import"? Did you mean export/import indexes separately? I guess I could do that. Right now I just try to keep the program simple because the time is not an issue. I just want to know if there is an "easy and simple" way to increase the imp speed without changing the program too much.

Guang

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> Ron Thomas
> Sent: Tuesday, May 27, 2003 1:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: would imp speed affect by setting indexes to NOLOGGING?
>
>
>
> Have you considered dropping the indexes before import, then
> rebuilding parallel nologging?
>
> Ron Thomas
> Hypercom, Inc
> rthomas_at_hypercom.com
> Each new user of a new system uncovers a new class of bugs.
> -- Kernighan
>
>
>
>
>
> gmei_at_incyte.com
>
>
> Sent by: To:
> ORACLE-L_at_fatcity.com
>
> root_at_fatcity.com cc:
>
>
> Subject:
> would imp speed affect by setting indexes to NOLOGGING?
>
>
>
>
> 05/27/2003 11:19
>
>
> AM
>
>
> Please respond to
>
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
>
>
>
> Hi,
>
> Would the imp speed increase by setting all indexes to NOLOGGING?
>
> I have a schema with 249 tables and 442 indexes and I have a
> weekly schema
> refresh program running as this:
>
> exp schema from Server A (Oracle 8173 on Sun Solaris box)
> ftp dump file from Server A to Server B, the dump file size
> is 1.9GB after
> compression
> imp schema on Server B (also Oracle 8173 on Sun Solaris box), the imp
> usually take about 7 hours.
>
> With everything elase the same, last week I changed all indexes in the
> schema on Server A to "NOLOGGING" (they were all set to
> "logging" before),
> hoping to increase the speed of imp on Server B. Because I thought the
> "create index ... nologging" would reduce redo log writing, therefore
> increase the imp speed quite a bit (there are some big
> indexes there!). But
> this morning I found the imp still took about the same time as before,
> although I was told that the system I/O seems to be lower.
>
> Does anyone have similar experience? TIA.
>
> Guang
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: gmei
> INET: gmei_at_incyte.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ron Thomas
> INET: rthomas_at_hypercom.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: gmei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).