yeah I think he went from "you won't need a DBA" to "you will need lots of DBAs to manage all the different specialized features" :)
--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: > True: > > If you listened carefully to Larry at OOW, he backed off that > statement, > saying that the DBA is necessary to make sure that all of the > Oracle9i > features are implemented properly. > > 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 12:15 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: IMPORT TIME IS HIGH > > 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). > -- > 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!? Send your FREE holiday greetings online! http://greetings.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).
