RE: Performance problem: Loading data via insert

From: Abhishek Gurung <abhishek.gurung_at_hotmail.com>
Date: Fri, 14 Mar 2014 12:59:25 +0530
Message-ID: <BLU180-W65AE320399718BD618796CEA700_at_phx.gbl>



Hi Vijay,
thanks for replying.Yes we have gone through AWR but unable to identify the problem.The problem is we have a single file containing insert statements that are inserting data into multiple tablesalso we are not using any selects inside inserts to insert data in tables. RegardsAbhishek

Date: Fri, 14 Mar 2014 12:39:57 +0530
Subject: Re: Performance problem: Loading data via insert From: vijaysehgal21_at_gmail.com
To: abhishek.gurung_at_hotmail.com
CC: oracle-l_at_freelists.org

Abhishek,

For the load of data period have you gone through the AWR report to identify what's going on in the database, also what about the execution plan of the query in problematic database and other database. Without any of these information available, it's difficult to tell you what could be the issue.

Regards,
Vijay Sehgal.

On Fri, Mar 14, 2014 at 12:36 PM, Abhishek Gurung <abhishek.gurung_at_hotmail.com> wrote:

Hi Sameer,
Thanks for your reply.We have already done gone through the process of using hints and after analysis we decided not to use them.Also my concern is to identify the problem in database. As we are able to insert data in much less time in similar environment with much less hardware configuration but in production it is taking hell lot of time for that particular database instance every other database instances are running fine. ReagrdsAbhishek

Date: Fri, 14 Mar 2014 07:42:40 +1100
Subject: Re: Performance problem: Loading data via insert From: sameer.choudhari_at_gmail.com
To: carlos.sierra.usa_at_gmail.com
CC: abhishek.gurung_at_hotmail.com; oracle-l_at_freelists.org

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                                                                                                

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 14 2014 - 08:29:25 CET

Original text of this message