How to display Oracle schema size with SQL query?

The Solution to How to display Oracle schema size with SQL query? is


You probably want

SELECT sum(bytes)
  FROM dba_segments
 WHERE owner = <<owner of schema>>

If you are logged in as the schema owner, you can also

SELECT SUM(bytes)
  FROM user_segments

That will give you the space allocated to the objects owned by the user in whatever tablespaces they are in. There may be empty space allocated to the tables that is counted as allocated by these queries.

~ Answered on 2012-03-12 16:50:11


Most Viewed Questions: