Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tuning.......!!!

RE: Tuning.......!!!

From: lerobe - Lee Robertson <>
Date: Fri, 8 Dec 2000 10:58:28 -0000
Message-Id: <>

Have you reanalyzed your tables since the inserts and updates. It could be that your stats are out of date.


> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email:

-----Original Message-----
From: Dash, Saroj (CAP,CEF) [] Sent: 08 December 2000 08:36
To: Multiple recipients of list ORACLE-L Subject: Tuning.......!!!

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.

Please see the official ORACLE-L FAQ:
Author: Dash, Saroj  (CAP,CEF)

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
Received on Fri Dec 08 2000 - 04:58:28 CST

Original text of this message