Re: best case scenarios for export/import

a month ago on MS NT 4.0, I imported a 70 gig dump file in 9.5 hours. That time includes creating the indexes.
I can't remember what the totall size used in the database... config:
8.1.7.2.3
Win NT 4.0 Svc. Pack 6a

There's also a brand new EMC Symmetrix on the backend

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, December 20, 2002 8:04 AM

> Good day, all:
>
> I'm looking for real-life best-case scenarios for running import/export .
.
> . I've been playing with this for quite some time and would like to know
how
> "fast" I can really expect this to go, particularly for the import.
>
> I'd be interested to hear others' experiences - how fast have you been
able
> to import data? what parameters have you used? etc. . . . it's both for
> informational purposes and as a sanity check.
>
> For example: I'm now trying to import a dump file of appx 6.5 Gb - breaks
> down into 12G data and 4G indexes.
> using the following params on the first import, to just get the data (I
then
> rerun with the indexfile param to get the indexes):
> recordlength=65535
> buffer=15000000 (15M)
> commit=y
> indexes=n
> constraints=n
> grants=n
>
> This will import in appx 36 hours using a single 3 Gb rollback segment
>
> What kind of experiences have you had?
>
> Thanks
> bill
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Magaliff, Bill
> INET: Bill.Magaliff_at_lendware.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: Steve Perry
  INET: sperry_at_sprynet.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).