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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
