Re: Performance problem: Loading data via insert
Date: Thu, 13 Mar 2014 08:18:12 -0400
Message-ID: <CAGd4=DRwBTMo07kLGGzJNaTERJEZ3Rb=BaJ5CU77dho8TkwuvA_at_mail.gmail.com>
I'd start by comparing execution plans on the production machine with the plans on the smaller non production machine.
Steve Harville<https://apex.appshosting.com/pls/apex/f?p=1076:steveharville>
On Thu, Mar 13, 2014 at 7:52 AM, Abhishek Gurung < abhishek.gurung_at_hotmail.com> wrote:
> Hi
>
> We are facing a performance problem but unable to identify where is the
> problem.
>
> We have a production database server where about 8 database instances of
> oracle is running.
> Daily we insert in each of these database instances about 1-5 GB of data
> in different tables.
> All database instances are working fine where we are able to load around
> 2-3 GB of data within 1hour except
> 1 where it is taking about 8 hrs to load only 4 GB of data.
>
> When I try to load the same 4GB of data in another database where only one
> instance is running and with
> very less configuration as compared to the Production server we were able
> to load it in 1hr 45 minutes.
>
> Can anyone suggest how can we proceed to identify the problem?
>
> Regards
> Abhishek
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 13 2014 - 13:18:12 CET