Re: size of user

I recommend using a scale built-in to their ergonomic seat. :)

Andy

PS ..

SELECT sum(bytes)/1024/1024 AS MEGABYTES FROM user_segments

SELECT segment_type, sum(bytes)/1024/1024 AS MEGABYTES FROM user_segments
GROUP BY segment_type
ORDER BY segment_type

SELECT owner, segment_type, sum(bytes)/1024/1024 AS MEGABYTES FROM dba_segments
GROUP BY owner, segment_type
ORDER BY owner, segment_type

SELECT owner, sum(bytes)/1024/1024 AS MEGABYTES FROM dba_segments
GROUP BY owner
ORDER BY owner

-- 
Andrew Finkenstadt (http://www.finkenstadt.com/andy/)