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>
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