Oracle-L: RE: IMPORT sloooowwww

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 29 Aug 2002 09:48:32 -0800
Message-ID: <F001.004C2C88.20020829094832@fatcity.com>

How many redo log files you have and what are the sizes for these files?

Chech the frequency of switch log and also check checkpoint frequency.

It looks like the DB has a severe contention problem. What is the size of shared_pool and buffer_cache?

Regards,

Waleed

-----Original Message-----
Sent: Thursday, August 29, 2002 11: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:

Simple import.
Import with indexes=n
Import with table and constraints (but not indexes) pre-created and indexes=n ignore=y
All of the above with the buffer set to 8M (This actually slows the import down, taking 5+ minutes per table).
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: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------