Each column of type LONG VARCHAR that is specified in a select statement will require a 32,700 byte segment to be allocated. However, only one such segment will be allocated for each such column, no matter how many rows are fetched.