cancel
Showing results for 
Search instead for 
Did you mean: 

Load Balancing - Duplicates

Suresh_31
Occasional Visitor

Load Balancing - Duplicates

I am running a process that needs to now run on multiple instance to balance the load. The Process takes a row from the input table and ... processes it and writes to a output table. When i go for multiple instance
i have a problem of multiple process processing the same row. How can this be avoided ... i have some more issues on the same lines... Is there any resource where i can look for such kind of issues.
Thanks,
Suresh
2 REPLIES
Michael Steele_2
Honored Contributor

Re: Load Balancing - Duplicates

Sounds very much like synchronous writing vs. asychronous, which is a common enough application problem. And inter process communication which is a semaphore relation. But all of this is resolved via code within the application.

You should be able to detect this with some performance reports. Here are the most useful. (* Note disk and I/O activity with -d and CPU resources with -m *)

sar -d 5 5
sar -m 5 5
sar -v 5 5
vmstat 5 5
Support Fatherhood - Stop Family Law
Brian Crabtree
Honored Contributor

Re: Load Balancing - Duplicates

Suresh,

Can you doa quick outline of your current enviroment and what you are looking at for the future? (ie: OPS/RAC cluster, replication, etc).

Thanks,

Brian