Actually,
How does this look? Any other, better suggestions?
SELECT owner,
concat( Sum(bytes)/1024 , 'KB') AS total_size_kb
FROM dba_segments
GROUP BY owner
"Winbatch" <winbatch_at_techie.com> wrote in message
news:ajpgdj$ja1$1_at_bob.news.rcn.net...
> Hi,
> This may be a simple question. How do I find out the size of each schema
in
> the database? (I don't mean the potential or allotted size, but the
actual
> size of the schemas in the db). I have system level access so any/all sql
> can be run.
>
> Thanks,
> Winbatch
>
>
Received on Sun Aug 18 2002 - 20:36:33 CDT
