title: How to find biggest table in each tablespace in Oracle
body: <p>I create following SQL statement but it show me biggest tables in general. I want to see it for each tablespace.</p>
  
  <pre><code>select tablespace_name, max(BYTES/1024/1024), SEGMENT_NAME 
  from dba_segments 
  where SEGMENT_TYPE='TABLE' 
  group by tablespace_name,SEGMENT_NAME,tablespace_name
  </code></pre>
  
  <p>Any ideas?</p>