Re: SQL Loader Performance issue after Oracle8i

Prior to your load did you computed statistics for all the objects referenced by the trigger? If computing statistics does not improve things and you were using the rule based optimizer in your pre-migration Oracle system then you may need to add hints to your trigger code to force a rule based optimizer plan. One last thought, you did check that all your indexes are still present and valid in the new system?

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Rajendran Kumaraguru" <rajendran.k_at_pacific.net.sg> wrote in message news:a95gtg$4ip$1_at_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:50:29 CDT