To see if its a straight load issue, try export with indexes=n, constraints=n, everything else you can think of = n, so on import it will basically be a batch insert and nothing else.
THen either trace the import, or take a look at v$session_event whilst the import is running and see where the delays are occurring. I'd hazard a guess at redo log problems causing long delays for checkpoints to complete, but a trace will reveal all hth connor --- "Ball, Terry" <[EMAIL PROTECTED]> wrote: > I tried this at your suggestion (though it didn't > look like it was analyzing > as there were not status on the tables). This > didn't help. I even tried > turning off archiving and no joy. > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1800 > > > -----Original Message----- > Sent: Thursday, August 29, 2002 11:18 AM > To: [EMAIL PROTECTED] > > > Sounds strange and I can't give you any good reason > but I do have one idea. > Have you tried: > analyze=n > > Kevin Kennedy > First Point Energy Corporation > > If you take RAC out of Oracle you get OLE! What can > this mean? > > -----Original Message----- > Sent: Thursday, August 29, 2002 8:23 AM > To: Multiple recipients of list ORACLE-L > > > Oracle 8.1.7 on Solaris 8 > > I am testing and upgrade from 7.3.4 to 8.1.7. > Because the test server is > solaris 8, and I can't find the patches for 7 > anymore, I am trying to > upgrade via an export and import. Besides, the DB > is small - less than 2G. > The export was done with compress=n. There are 200+ > tables to be imported. > It is taking 3+ minutes per table for the import, > even on tables that have 0 > rows. (Though it does take longer than that for the > few tables with over > 50K rows). > > I have tried: > 1) Simple import. > 2) Import with indexes=n > 3) Import with table and constraints (but not > indexes) pre-created and > indexes=n ignore=y > 4) All of the above with the buffer set to 8M > (This actually slows the > import down, taking 5+ minutes per table). > 5) Increasing the sort_area_size for the DB to > twice as large as it was > and trying the above. > > In looking at how long it takes, the table imports > in a second or less, but > it takes 3 minutes + to start the import of the next > table. I'm not sure > what it is doing for 3 minutes after the table > imports. > > Does anyone have any ideas how I can speed this up? > 10 hours to import a > 2G. DB is extreme and unacceptable. > > TIA. > > Terry > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1800 > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ball, Terry > 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: Ball, Terry > 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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
