title: How do I select all my user tables and list its size along with it in sql plus?
body: <pre><code>SELECT table_name , (SELECT (sum(bytes)/1024) "SizeinKB" FROM dba_segments) AS KB
  FROM user_tables
  ORDER BY table_name;
  </code></pre>
  
  <p>This lists all my user table and the total space taken by database. How do I show each table along with its total size used? Im on sql plus. Thank you.</p>