title: How to find Memory SIZE of records returned in a SQL Query in Oracle?
body: <p>I am hitting a query which returns 10,000 Records.</p>
  
  <pre><code>SELECT * FROM employee WHERE id &lt; 11000;
  </code></pre>
  
  <p>The data returned consists of 85 Columns (varchar, date, no.). 
  (Also i have another similar query gets data consist of just 10 columns(varchar).)</p>
  
  <p>Is there any way in Oracle to find the data size of this resultset? Like the data loaded will be of 100 MB or 200 MB</p>
  
  <p><strong>Requirement</strong>: Actually i need to load all records in memory; for these records for some processing in Java. So i need to check size of data using some preconditions in Oracle or Any other appropriate way you can suggest to check same? (I have production access. So i will implement logic after checking data size). </p>
  
  <p>This precheck is just to avoid Out of memory exceptions in java.</p>
  
  <p>IF i copy whole data and save it in file it shows only 604 KB for 10,000 records having 8 columns. Does the same will there in memory?</p>