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: Stephen.Karniotis_at_Compuware.com
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" <Stephen_Karniotis_at_compuware.com> 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: Stephen.Karniotis_at_Compuware.com
> 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 <sfaroult_at_oriole.com> 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: sfaroult_at_oriole.com
> >
> > 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: 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).
>
>
> __________________________________________________
> 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: wisernet100_at_yahoo.com
>
> 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: 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.com
> --
> Author: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.com
>
> 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: 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).
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: wisernet100_at_yahoo.com
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: 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.com
--
Author: Karniotis, Stephen
INET: Stephen_Karniotis_at_compuware.com
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: 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).
Received on Fri Dec 21 2001 - 12:43:58 CST
