| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to do solve this problem !!!
Saroj,
Taken from www.orafaq.com
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.
HTH
Suhen
-----Original Message-----
From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash_at_gecapital.com]
Sent: Monday, December 11, 2000 1:11 PM
To: Multiple recipients of list ORACLE-L
Subject: How to do solve this problem !!!
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj (CAP,CEF)
INET: Saroj.Dash_at_gecapital.com
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: ListGuru_at_fatcity.com (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
 |
 |