Performance problem: Loading data via insert

From: Abhishek Gurung <abhishek.gurung_at_hotmail.com>
Date: Thu, 13 Mar 2014 17:22:03 +0530
Message-ID: <BLU180-W310C33D2F998B65E948344EA710_at_phx.gbl>



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
Received on Thu Mar 13 2014 - 12:52:03 CET

Original text of this message