Hello all,

I have two machines running the same database (replicated), but
accessed by 2 different applications. Machine A does have more
activity on it:
On Machine A:
# ps -ef | grep fb_inet_server | wc -l
92

On Machine B:
# ps -ef | grep fb_inet_server |wc -l
46

However, 'top' shows very peculiar CPU states.
On Machine A, it is normaly about an average of 25% user, 10% system
and 65% idle.
On Machine B, it is normaly about an average of 90% user, 7% system, 1% idle.

Both machines have exactly the same specification. Why is Machine A
relaxing even though it has more work to do? Is there a way I can
drill down which query/trigger consumes the most resources?
Thanks!

Regards,
Faisal


--
There are many ways of going forward, but there is only one way of
standing still.