SQL Loader Performance issue after Oracle8i

From: Rajendran Kumaraguru <rajendran.k_at_pacific.net.sg>
Date: Fri, 12 Apr 2002 10:31:09 +0800
Message-ID: <a95gtg$4ip$1@newton.pacific.net.sg>

Hi,

I have a performance issue while loading the data thru sql loader. SQL Loader loads the data 30000 records per hour to a global partitioned table (it has about 120 million records).
There is a database trigger attached to the loading table and which is inserting/updating some records in another table which has 10 million records. We have migrated our database to Oracle8i, after the migration it is taking more than one hour to complete the loading, before the oracle8i migration it took only less than 20 mins time, also there is no changes in the control file and the loading table so far.

Can you please help me any tuning parameter that I have to add.

Thanks in advance.
Guru Received on Thu Apr 11 2002 - 21:31:09 CDT