Re: Performance problem: Loading data via insert

From: Mark Bobak <Mark.Bobak_at_proquest.com>
Date: Fri, 14 Mar 2014 14:27:08 +0000
Message-ID: <CF4889F0.55876%Mark.Bobak_at_ProQuest.com>



NOLOGGING is *not* a hint.

From: Jeff Smith <jeff.d.smith_at_oracle.com<mailto:jeff.d.smith_at_oracle.com>> Reply-To: Jeff Smith <jeff.d.smith_at_oracle.com<mailto:jeff.d.smith_at_oracle.com>> Date: Friday, March 14, 2014 at 8:37 AM
To: "william_at_williamrobertson.net<mailto:william_at_williamrobertson.net>" <william_at_williamrobertson.net<mailto:william_at_williamrobertson.net>>, Oracle Freelist <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: RE: Performance problem: Loading data via insert

It gets complicated. AskTom has a few posts on this subject https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5280714813869

From: William Robertson [mailto:william_at_williamrobertson.net] Sent: Friday, March 14, 2014 3:41 AM
To: Oracle Freelist
Subject: Re: Performance problem: Loading data via insert

I think we'd all be interested in any documentation on the NOLOGGING hint.


[cid:image001.jpg_at_01CF3F60.AA1077D0]

Sameer Choudhari<mailto:sameer.choudhari_at_gmail.com> 13 March 2014 23:30

Yes, I have read the notes as well documents.

Cheers,
Sameer<http://www.choudhari.net>


[cid:image001.jpg_at_01CF3F60.AA1077D0]

Jeff Smith<mailto:jeff.d.smith_at_oracle.com> 13 March 2014 21:34

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_at_gmail.com] Sent: Thursday, March 13, 2014 4:43 PM
To: carlos.sierra.usa_at_gmail.com<mailto:carlos.sierra.usa_at_gmail.com> Cc: abhishek.gurung_at_hotmail.com<mailto:abhishek.gurung_at_hotmail.com>; 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_at_gmail.com<mailto: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<http://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<javascript:_e(%7B%7D,'cvml','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
________________________________


[cid:image001.jpg_at_01CF3F60.AA1077D0]
Sameer Choudhari<mailto:sameer.choudhari_at_gmail.com> 13 March 2014 20:42 Try tuning your insert statements with hints like PARALLEL NOLOGGING . On Friday, 14 March 2014, Carlos Sierra <carlos.sierra.usa_at_gmail.com<mailto:carlos.sierra.usa_at_gmail.com>> wrote: -- Sent from Google Nexus


-- http://www.freelists.org/webpage/oracle-l
image001.jpg
Received on Fri Mar 14 2014 - 15:27:08 CET

Original text of this message