Oracle CPU_COUNT

Hi

I have a Compaq DL580 server with 2 Xeon P1.7 processors; the server is set up with hyper threading. I have installed Win2K Advanced Server and Oracle 9.0.2 running a live database. When I open task manager it appears that I have 4 processors and they are all getting used. I checked oracles CPU_COUNT and it is set at 4. My question is

Will I see a performance improvement if I turn off the hyper threading and change the CPU_COUNT to 2?

I have read that it is not recommended to change the CPU_COUNT would I be better uninstalling and re-installing oracle and let it pick this up for itself or is there another option, I can afford to have the database down for a weekend?

Thanks in advance

Carol Received on Tue Oct 29 2002 - 05:02:12 CST