Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to do solve this problem !!!

RE: How to do solve this problem !!!

From: Suhen Pather <>
Date: Mon, 11 Dec 2000 13:54:03 +1100
Message-Id: <>


Taken from

Which tables are currently analyzed? Were they previously analyzed? (ie. Was the query using RBO and now CBO?)
Has OPTIMIZER_MODE been changed in INIT.ORA? Has the DEGREE of parallelism been defined/changed on any table? Have the tables been re-analyzed? Were the tables analyzed using estimate or compute? If estimate, what percentage was used? Have the statistics changed?
Has the INIT.ORA parameter DB_FILE_MULTIBLOCK_READ_COUNT been changed? Has the INIT.ORA parameter SORT_AREA_SIZE been changed? Have any other INIT.ORA parameters been changed?

Look for chaining/row migration in those tables concerned.

Try to isolate the jobs into smaller jobs. Look at which insert job has poor response.
Tune that job.


-----Original Message-----
From: Dash, Saroj (CAP,CEF) [] Sent: Monday, December 11, 2000 1:11 PM
To: Multiple recipients of list ORACLE-L Subject: How to do solve this problem !!!

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). Received on Sun Dec 10 2000 - 20:54:03 CST

Original text of this message