advanced code snippet search

Posted By

geekzspot on 01/25/13


Tagged


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

geekzspot
bcmoney


Oracle Schema Size

 / Published in: SQL
 

Show the size for all your database schemas

Expand | Embed | Plain Text 
  1. SELECT owner, ROUND(SUM((num_rows*avg_row_len))) AS bytes 
  2. FROM all_tables 
  3. WHERE num_rows > 0
  4. AND owner NOT LIKE 'SYS%'  -- exclude system tables
  5. GROUP BY owner
  6. ORDER BY bytes DESC
  7. ;

Report this snippet  

You need to login to post a comment.