Re: Batch and OLTP at the same time : Mission possible ?

Bertrand,

Okay, to put it into simple terms:

• You currently do the batch task during off-hours and now you are being asked to move the task to the times when the database is busy?
• Most of the batch activity is inserts, with just a few updates?

If your site is equipped to do perfomance testing of the database, that would be ideal. Simulate the interactive load, then start the batch process. But if you are like most of us, that doesn't exist.

My advice would be to "start slow". Get baseline performance readings with just the interactive load. STATSPACK does a good job for that sort of thing. Also, (per Cary Millsap) try to measure current interactive user response from the user's terminal as accurately as possible. If the batch job is running off-hours now, get baseline performance readings while it is running also. You may be able to get a rough idea of the combined database load

--
http://www.freelists.org/webpage/oracle-l