Re: newbie question: size of schemas sql
Date: Mon, 19 Aug 2002 15:10:53 +1000
Message-ID: <3D607DDD.350E5581_at_bigpond.com>
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 - 07:10:53 CEST