Re: Performance problem: Loading data via insert

From: Veerabasaiah C <veeracb_at_gmail.com>
Date: Fri, 14 Mar 2014 10:01:25 +1300
Message-ID: <CAKE9HuOxAJwJMXRUWb2GpQ_KLMZPMfqGKQGSLKjXOgcXPYc4aA_at_mail.gmail.com>

Do you always load the data or cleanup some old data before inserting ? What else is running at the same time the load is running, is something blocking this load ?

As Carlos suggested, it would be better if you get more data around the problem and try identify where your time is going.

On Fri, Mar 14, 2014 at 9:42 AM, Sameer Choudhari < sameer.choudhari_at_gmail.com> wrote:

> Try tuning your insert statements with hints like PARALLEL NOLOGGING .
>
>
> On Friday, 14 March 2014, Carlos Sierra <carlos.sierra.usa_at_gmail.com>
> wrote:
>
>> Abhishek,
>>
>> As always, start with the evidence:
>> What facts have you collected? What is AWR telling you? What are the SQL
>> Traces telling? Which other diagnostics tools have you used for your case?
>>
>> Cheers,
>>
>> Carlos Sierra
>>
>> blog: carlos-sierra.net
>> twitter: _at_csierra_usa
>>
>> Life's Good!
>>
>> On Mar 13, 2014, at 6: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
>>
>>
>>
>
> --
> Sent from Google Nexus
>

-- 
Veerabasaiah C B
"Only put off until tomorrow what you are willing to die having left
undone. - Picasso"

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 13 2014 - 22:01:25 CET