Hi,
It is important to note that fetch size only works when autocommit is off. The implication here is:
1) fetch size has no bearing whatsoever for most people.
2) You have to know that fetch size only works in a transaction so you should be sophisticated enough to set it.
OTOH, I have no objection to setting it to say 100