Re: Performance problem: Loading data via insert

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

--
http://www.freelists.org/webpage/oracle-l