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" <TBall_at_birch.com> 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: TBall_at_birch.com
>
>
> 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: TBall_at_birch.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: Ball, Terry
> INET: TBall_at_birch.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).
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: hamcdc_at_yahoo.co.uk
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 Thu Aug 29 2002 - 16:43:35 CDT
