Размер БД Oracle внутри табличных пространств

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

+