Re: How to determine oracle user size?(B

From: gazzag(B <gareth_at_jamms.org>
Date: Thu, 19 Feb 2009 08:36:46 -0800 (PST)
Message-ID: <260a1d2b-e3ed-4e2f-934e-b4fb44978b6d_at_v13g2000yqm.googlegroups.com>



On 19 Feb, 15:05, Ming$BGl(B <l..._at_tech-trans.com> wrote:
> On 2$B7n(B19$BF|(B, $B2<8a(B12$B;~(B47$BJ,(B, Ram <krishna..._at_gmail.com> wrote:
>
>
>
>
>
> > On Feb 19, 7:15 am, Ming$BGl(B <l..._at_tech-trans.com> wrote:
>
> > > Hi
>
> > > Any SQL statement can find theOracleuser/ownersizewhen more than
> > > oneuserin aOracleinstance? Thx!
>
> > > Ming
>
> > Hi,
>
> > select sum(bytes/1024/1024)"size" from dba_segments where
> > owner='&owner';
>
> > Regards
>
> > RAM
>
> RAM,
>
> I executed the your sql statement but no result acquired. Any idea?
>
> Ming

Ming,

It means that the owner you specified owns no objects in the database.

HTH -g Received on Thu Feb 19 2009 - 10:36:46 CST

Original text of this message