RE: Import to Oracle9i extremely slow

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 26 Mar 2003 09:14:23 -0800
Message-ID: <F001.005735D5.20030326091423@fatcity.com>

We also ...

1. created tables first ... with no indexes and no constraints.
2. Prepared a constraints script
3. drop all triggers.
4. Imported data in multiple streams (in our case 6 import processes on each node X 2 nodes) with different tables listed in parfile with no constraints, no statistics, we let the indexes be created
5. After imprt Enabled constraints
6. recreate table triggers
7. verify if everything is okay ... if it is, shutdown, cold backup and restart
8. collect stats in multiple streams
9. Enable archivelog mode
10. switch logfiles ...
11. shutdown take full backup
12. database is open for business.

Not all of these will suit you, but importing in multiple streams (even if from the same export file) is beneficial BTW this was when we moved from 8161 to 9201. Kirti's email helped us tune it further.

Raj

---

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Wed Mar 26 2003 - 11:14:23 CST