Re: How to determine oracle user size?

From: Paulie <linehan.paul_at_gmail.com>
Date: Thu, 19 Feb 2009 08:20:08 -0800 (PST)
Message-ID: <28129d6c-3336-4437-930f-9478939a50f2_at_l1g2000yqj.googlegroups.com>


On Feb 19, 3:05 pm, Ming伯 <l..._at_tech-trans.com> wrote:

> > select sum(bytes/1024/1024)"size" from dba_segments where
> > owner='&owner';

> I executed the your sql statement but no result acquired. Any idea?

There has to be a result!

Show us what SQL you ran (*_EXACTLY_*), preferably copy and paste the SQLPlus session into the post.

Try

SELECT owner, sum(bytes/1024/1024)"size" FROM dba_segments
GROUP BY owner

Run this as SYSDBA.

Show us the output.

Paul...

> Ming
Received on Thu Feb 19 2009 - 10:20:08 CST

Original text of this message