Re: Oralce 8i performance

Try to discover this problem using Statspack utility.

On Sat, 18 May 2002 17:50:29 +0800, "Rajendran Kumaraguru" <rajendran.k_at_pacific.net.sg> wrote:

>Hi,
>
>We had a problem while inserting the records into a global partition table.
>1. We have pro*c program to insert the records to a global partition table
>let's say table1 it has about 120 million records per year (10 million per
>month).
>
>2. While inserting the records the program will do the select from another
>table let's say table 2 ( size 10million records, global partition) and do
>the insert or update to table2 by using proper index.
>
>3. Finally the program is inserting the records to another 2 local partition
>tables (let's say table 3,4).
>
>We used sql loader with 2 database triggers:
>Trigger one will fire only on table 2.
>Trigger two will fire to table 3 and 4.
>
>Currently we had the problem on this process, we are loading the data by
>every hour but it is taking more than one hour for just 22,000 records, we
>are not able to complete each hour process within the hour itself. This
>problem occurred only after we migrated to Oracle8i.
>
>Is there any way to solve this performance issue?
>
>Your help is very much appreciated.
>
>
>Thanks
>Guru
Received on Mon Jun 10 2002 - 00:50:03 CEST