By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
This is a very simple statement but should give you what you want. Try this:
select owner, sum(bytes)/(1024*1024) "SUM Mb", sum(extents) "EXTENTS" from dba_segments where owner = UPPER('&the_user') group by owner order by 1, 2 /
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.