"mal.oracledba" writes:
> A snapshot of 'perf' output for one of the users below. It doesnt change
> much from that profile.
You might want to look into whether you could use int or bigint instead
of numeric for your indexed columns. That trace is showing 4.5% of
runtime directly blamable on cmp
CPU on the server shows approx 60% used/40 % idle
vmstat 5 5
procs ---memory-- ---swap-- -io --system--
-cpu-
r b swpd free buff cache si sobibo in cs us sy id
wa st
18 0 0 160465072 455200 3521852480037 42120
