Home » RDBMS Server » Performance Tuning » Batch Job performance.
Batch Job performance. [message #65210] Mon, 14 June 2004 18:26 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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 !.
Previous Topic: Oracle SQL statements Case sensitive for Performance?
Next Topic: db_cache_size
Goto Forum:
  


Current Time: Wed Feb 21 12:46:26 CST 2024