title: Where Result set is stored while working with jdbc and oracle driver
body: <p>Once I use jdbc with oracle driver and run select query is the result of the query is stored in the server of oracle memory or file system or temp table ?</p>
  
  <p>and once I run the next method by getting the next row is it loaded from the oracle server memory to the jvm memory ?</p>
  
  <p>And in case I define the the number of fetch size on the result set to be 1000 is this mean that the 1000 rows are loaded from the oracle to the JDBC driver on the JVM?</p>