Re: How to determine oracle user size?

From: gazzag <gareth_at_jamms.org>
Date: Thu, 19 Feb 2009 08:40:30 -0800 (PST)
Message-ID: <e5370ce2-3b49-4eda-b389-43e55f255f9b_at_m15g2000vbp.googlegroups.com>

On 19 Feb, 16:20, Paulie <linehan.p..._at_gmail.com> wrote:
> There has to be a result!

Not necessarily. The schema in question might not own any objects.

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

Why as SYSDBA?

> Show us the output.
>
> Paul...

-g Received on Thu Feb 19 2009 - 10:40:30 CST