A very short notice. If you have a really huge resultset that you only need to traverse once in one direction never use ResultSet.TYPE_SCROLL_INSENSITIVE or ResultSet.TYPE_SCROLL_SENSITIVE, in Oracle. Only the ResultSet.TYPE_FORWARD_ONLY.
Today I worked on one of our numerous OutOfMemory problems that had to do with a large resultset. Oracle driver appears to be caching the CachedRowElement’s in memory!!!
First published on the old anydoby.com blog on 2011-03-23.