Dear list,
I have a discussion with my fellow DBA about the difference between database
contention and wait, we had a billing process which run in parallel,
multiple instances of the billing program was run to process different
ranges of account (it is not parallel query in Oracle). We are discussing
how to improve performance of the billing process, one possibility is to
increase number of instances of billing process from 4 to 8 since the
machine (4 CPUs) are not very busy when the billing processes were running.
I argue that if there is contention (result in wait) in the database then
increase the number of processes will only make it worst. My fellow DBA said
contention and wait are two different things, I disagree about what he said,
the two things are different in nature, however in my opinion a lot of waits
are result of contention, isn't Oracle records contention in wait
statistics?? Anyone who can clarify this??
Received on Mon May 22 2000 - 09:25:50 CDT
