Re: Performance problem: Loading data via insert
- From: vijay sehgal <vijaysehgal21@xxxxxxxxx>
- To: abhishek.gurung@xxxxxxxxxxx
- Date: Fri, 14 Mar 2014 13:29:05 +0530
Abhishesk,
As mentioned that the tables are created / altered, have you compared
schema between databases for any difference, if not can you do that?
Regards,
Vijay Sehgal.
On Fri, Mar 14, 2014 at 12:59 PM, Abhishek Gurung <
abhishek.gurung@xxxxxxxxxxx> wrote:
> 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 tables
> also we are not using any selects inside inserts to insert data in tables.
>
> Regards
> Abhishek
>
>
> ------------------------------
> Date: Fri, 14 Mar 2014 12:39:57 +0530
> Subject: Re: Performance problem: Loading data via insert
> From: vijaysehgal21@xxxxxxxxx
> To: abhishek.gurung@xxxxxxxxxxx
> CC: oracle-l@xxxxxxxxxxxxx
>
> 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@xxxxxxxxxxx> 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.
>
> Reagrds
> Abhishek
>
> ------------------------------
> Date: Fri, 14 Mar 2014 07:42:40 +1100
> Subject: Re: Performance problem: Loading data via insert
> From: sameer.choudhari@xxxxxxxxx
> To: carlos.sierra.usa@xxxxxxxxx
> CC: abhishek.gurung@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>
> 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:
