title: Discover what process/query is using the oracle SGA
body: <p>I have a query to monitor SGA (non-)utilisation:</p>
  
  <pre><code>select sum(bytes)/1024/1024 " SGA Free " from v$sgastat where name='free memory';
  </code></pre>
  
  <p>That's great, but I need more detail about what exactly is using the space. Essentially, I'm looking for clues to tell me more precisely what might be wrong with this (rather large application).</p>
  
  <p><code>select * from v$sgastat</code> does not give me anything that I recognise as a developer - at least not without some pointers.</p>