Find Schema size

[oaklanders]

I am trying to find out how big my Schema is in Oracle 9i.

This SQL seems to give the total amount of space that I have used in my Schema?

SELECT tablespace_name, 
Sum(bytes)/1024/1024 AS total_size_mb
FROM dba_segments
WHERE owner = MYSCHEMANAME

How do I find the total size of my what I can use in my Schema?

 

[hoinz]

A similar question recently has been asked in Oracle 10g forum, and the answer should work for Oracle 9i, too.

Have a look at thread thread1177-1444149
Does this answer your question?

 

[Dagon]

Or, if you're not using quotas, just look at sys.dba_free_space for the tablespaces to which you have access.