I have a quick issue and I need some advise on this.

I have an Oracle server running windows 2000 server with 933 MHZ and 1.2 G of memory. I have 6 8 databases running on this box and the total memory allocated to these databases are about 800M.

everytime when someone do and insert or update to anyone of these databases, I look at the CPU and it's max out 100% and every body else experience the performance issues on the whole box.

I looked at the swap file and It's not bad at all. So what could be the problem ??? need more memory on the Box ??? add another CPU ????

How to approach this problem, please advise.

Thanks