Ask the Expert

Space occupied by scott/tiger

I want to find space occupied by scott/tiger (or any other) schema in database. Please send me simple script to find out.

    Requires Free Membership to View

    Login

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
/

This was first published in March 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top