depending on what manufacturer of motherboard you have, you would have to go to their site in order to upgrade bios.
C2Ds are the best dual core out there right now, due to their overclockability and power consumption and sheer power. As far as im concerned, im never going to own one, becuase i guarantee you my opteron is just as fast as any e6600/e6300 out there. AMD X2 3800 was AMD's first stab at dual core, which they proceeded very well, and you will definately be able to notice a difference from your 3200. you will now be able to play CSS, download music, and render a movie without much stress.