Above one Gig is overkill. Unless you are into heavy video editing or CAD programs. Then it still may be too much.
i currently have 1gb of ddr2 ram (533mhz) iam considering upgrading to 2gb. will this make a noticeable difference in performance? (my system is a dell dimension 8400 3.2 gig p4 h/t 160 gb hard drive ati radeon x300se 128mb pci express graphics card

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic