Yes, I have read the notes as well documents. Cheers, Sameer <http://www.choudhari.net> On 14 March 2014 08:34, Jeff Smith <jeff.d.smith@xxxxxxxxxx> wrote: > Please read the docs on the NOLOGGING hint before you ever actually use it. > > > > Actually, for any hint, but esp that one. > > > > *From:* Sameer Choudhari [mailto:sameer.choudhari@xxxxxxxxx] > *Sent:* Thursday, March 13, 2014 4:43 PM > *To:* carlos.sierra.usa@xxxxxxxxx > *Cc:* abhishek.gurung@xxxxxxxxxxx; Oracle Freelist > *Subject:* Re: Performance problem: Loading data via insert > > > > 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 >