Re: How to determine oracle user size?(B

From: Ming$BGl(B <leo_at_tech-trans.com>
Date: Thu, 19 Feb 2009 07:05:04 -0800 (PST)
Message-ID: <d9d92e76-2615-4922-b6d0-da46b5527f85_at_r36g2000prf.googlegroups.com>

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 Received on Thu Feb 19 2009 - 09:05:04 CST