Re: Performance problem: Loading data via insert
- From: Veerabasaiah C <veeracb@xxxxxxxxx>
- To: sameer.choudhari@xxxxxxxxx
- Date: Fri, 14 Mar 2014 10:01:25 +1300
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@xxxxxxxxx> wrote:
> Try tuning your insert statements with hints like PARALLEL NOLOGGING .
>
>
> On Friday, 14 March 2014, Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
> 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: @csierra_usa
>>
>> Life's Good!
>>
>> On Mar 13, 2014, at 6:52 AM, Abhishek Gurung <abhishek.gurung@xxxxxxxxxxx>
>> 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"
Other related posts:
