In oracle 10 it was possible to use OCI_ATTR_PREFETCH_ROWS with LOB columns, as the documentation states: Prefetching is not in effect if LONG columns are part of the query. Queries containing LOB columns can be prefetched, because the LOB locator, not the data, is returned by the query.
In oracle 11 the text has changed: Prefetching is not in effect if LONG, LOB or Opaque Type columns (such as XMLType) are part of the query.
Is there something new in oracle 11 that can be used/set to reduce the number of roundtrips to the server for queries with LOB columns?
Yes, this reduces the rountrips from 2 times the number of rows returned to the number of rows retruned. But without a LOB value i can get the same amount of data in only one roundtrip. Since i am trying to get the data over a 1 MBit DSL connection this is a problem.