SEO

#1 (**permalink**) 02-26-2008, 06:14 AM

Hello All,

Is-it possible with Enterprise Manager to know the Physical Disk Usage of a
schema ? I've multiple schema in the user tablespace, how can i know the
usage of my schema ?

thank's..

#2 (**permalink**) 02-26-2008, 06:14 AM

On 11 Jun, 15:40, "Jean-Luc" <t...@test.com> wrote:
> Hello All,
>
> Is-it possible with Enterprise Manager to know the Physical Disk Usage of a
> schema ? I've multiple schema in the user tablespace, how can i know the
> usage of my schema ?
>
> thank's..

>From the SQL*Plus command line, the following query will return the
amount of bytes used by all the objects in each of your schemas:

select owner, sum(bytes)
from dba_segments
group by owner;

HTH

-g

#3 (**permalink**) 02-26-2008, 06:14 AM

On Jun 11, 10:04 am, gazzag <gar...@jamms.org> wrote:
> On 11 Jun, 15:40, "Jean-Luc" <t...@test.com> wrote:
>
> > Hello All,
>
> > Is-it possible with Enterprise Manager to know the Physical Disk Usage of a
> > schema ? I've multiple schema in the user tablespace, how can i know the
> > usage of my schema ?
>
> > thank's..
> >From the SQL*Plus command line, the following query will return the
>
> amount of bytes used by all the objects in each of your schemas:
>
> select owner, sum(bytes)
> from dba_segments
> group by owner;
>
> HTH
>
> -g

select owner, sum(bytes)
from dba_segments
where tablespace_name = 'USER'
group by owner;

-or-

select owner, tablespace_name, sum(bytes)
from dba_segments
group by owner, tablespace_name;

David Fitzjarrell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Schema Disk Size