We use a query like this:
SELECT t1.thumbnail.Getbfile() thumbnail, title from sometable t1 where somefield=5
as a datasource for a (DevExpress) grid to display a thumbnail image and some other info for each row.
The OracleMonitor shows that for each row with a thumbnail, the LOB is opened and...