What kind of effect does alliteration create in wrting?

Question

http://en.wikipedia.org/wiki/Alliteration