Here's an excellent performance tuning guide by Atomizer, the guy who created the mod enabling below spec machines to run Oblivion. Highly recommended read: deals with improving visuals (substantial increases) and performance tweaks, with a mod section coming up soon.
Find it
here.
Update: He's now released part 3:
Modblivion. Worth a read to get started in the very fast moving mod scene
