Batch Job performance. [message #65210] |
Mon, 14 June 2004 18:26 |
vp
Messages: 25 Registered: January 2002
|
Junior Member |
|
|
Hi Guys,
We have a peculiar problem...Our batch job performance becomes worse everday...Can anyone give me some hints on the possible reason? No changes were made to the db parameter. Fragmentation is also not much. One thing which i observed was our daily dump increases by 75000K. I wonder if that can influence our performance to change from 5hrs to 15hrs.
Thanks in Advance,
vP
|
|
|
Re: Batch Job performance. [message #65214 is a reply to message #65210] |
Tue, 15 June 2004 03:52 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
seems you are loading huge volumne of data.
first
get ddl of indexes
drop the indexes.
load the data
recreate the indexes.
and if there are any queries involved, tune the queries !.
|
|
|