How to do solve this problem !!!

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Mon, 11 Dec 2000 11:09:51 +0900
Message-Id: <10706.124155@fatcity.com>

Hello,
I have a X and Y instance in WIN NT and oracle 8.0.5.In X instance there are T1,T1 tables.
Both instaneses are different server.
In Y instance there are Y1,Y2 .....tables.

There is a batch which is insert the data from X instances to Y instances. After inserting the data in Y instances it wait for one flag when flag=y then again there is another batch which is update the data in Y instances. those updated data again insert into in X instances.

The problem is;

When this batch runs previouly it takes 5 to 10 minutes. But Now it takes 1 hr.

The total Number of records are insertted in Y instanes are around 6000. after getting flag=y it updates and inserted in X instances around80,000 records.

so my question is whre is the problem .

I have seen the imporatnt tables are not fragmented .

so please tell me why is takes so much time. Received on Sun Dec 10 2000 - 20:09:51 CST