remove (not disable, REMOVE) constraints and drop indexes and recreate
after the import.
Change the buffer size on the import as well. Check to see if it is
committing after every row.
- "Ball, Terry" <TBall_at_birch.com> wrote:
> 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).
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.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).
Received on Thu Aug 29 2002 - 11:58:23 CDT