Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie question: size of schemas sql
Hi Winbatch
This will give you the allotted size of your objects. You said you didn't mean this figure ?
Cheers
Richard
Winbatch wrote:
>
> 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 Mon Aug 19 2002 - 00:10:53 CDT
![]() |
![]() |