Re: Performance problem: Loading data via insert
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "sameer.choudhari@xxxxxxxxx" <sameer.choudhari@xxxxxxxxx>, "carlos.sierra.usa@xxxxxxxxx" <carlos.sierra.usa@xxxxxxxxx>
- Date: Fri, 14 Mar 2014 07:47:30 -0700 (PDT)
http://dfitzjarrell.wordpress.com/2011/08/26/parallel-universe/
David Fitzjarrell
Primary author, "Oracle Exadata Survival Guide"
On Thursday, March 13, 2014 2:43 PM, 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
Other related posts:
