Googling around there seems to be mixed reports whether the size of a VARCHAR2 column in Oracle impacts performance or not.
I would like to give the question of VARCHAR size a little twist and hope to get some insight in this:
Given (multiline) free-text fields (not short stuff like names) that you want to store in an (Oracle) database, is there any point (wrt. performance or otherwise) in not maxing out the VARCHAR capacity (
VARCHAR2(4000) on Oracle) but choosing a smaller value such as 1024 or 512 because that will likely be sufficient in 98% of the cases anyway.