and svrmgr was going in 8i too... took them until 9i oh, and of course, my personal favorite (this has been said since 7) "you won't need a DBA anymore"
--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: > Everyone needs to remember that the Oracle Import Utility is just a > 3GL "C" > program with INSERT statements. It is widely publicized that the > ratio is > 1:4 so this should not come as a surprise to anyone. Some ways to > improve > performance is to use a large buffer size (10-20M) and set COMMIT=Y > to > facilitate array inserts. There are OS options for improving the I/O > bandwidth on the file, but that's really it. > > Rachel is correct. She did not want to frighten anyone. Now the > good news > is with Oracle9i, Oracle has added Array Inserts to the tool so this > may > help. How many of us remember when Oracle claimed that EXP/IMP were > to go > away in 8i???? > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email: [EMAIL PROTECTED] > Web: www.compuware.com > > > -----Original Message----- > Sent: Friday, December 21, 2001 10:25 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: IMPORT TIME IS HIGH > > well, yeah, depending on the number of indexes, I've seen a 6 hour > export take almost 24 hours to import -- on the same box as the > export > was done. > > I was trying not to frighten anyone :) > > > --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > > Rachel Carmichael wrote: > > > > > > in addition, define what you mean by "much time" -- how much data > > are > > > you loading? how slow is the load actually? I've found that in > > > general, an import takes about twice as long as the export. > > > > > > > Rachel, I don't know it's because of the festive season but I find > > you > > optimistic. I'd rather say 3 or 4 times as long as a conventional > > export. > > -- > > Regards, > > > > Stephane Faroult > > Oriole Ltd > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stephane Faroult > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > > __________________________________________________ > Do You Yahoo!? > Check out Yahoo! Shopping and Yahoo! Auctions for all of > your unique holiday gifts! Buy at http://shopping.yahoo.com > or bid at http://auctions.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > 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: [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.com > -- > Author: Karniotis, Stephen > INET: [EMAIL PROTECTED] > > 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: [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). __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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).
