Re: How to determine oracle user size?
From: Paulie <linehan.paul_at_gmail.com>
Date: Thu, 19 Feb 2009 13:53:13 -0800 (PST)
Message-ID: <71a046f7-f6e1-4280-bbf8-41241000dd01_at_p13g2000yqc.googlegroups.com>
Date: Thu, 19 Feb 2009 13:53:13 -0800 (PST)
Message-ID: <71a046f7-f6e1-4280-bbf8-41241000dd01_at_p13g2000yqc.googlegroups.com>
On Feb 19, 4:40 pm, gazzag <gar..._at_jamms.org> wrote:
> > There has to be a result!
> Not necessarily. The schema in question might not own any objects.
I didn't mean "240MB" - I meant a result of *_some_* sort - even if the user has no privileges or whatever.
An error would be thrown or something - can't think offhand exactly what, but the SQLPlus prompt would come back after something had been written to the screen.
> > Try
> > SELECT owner, sum(bytes/1024/1024)"size"
> > FROM dba_segments
> > GROUP BY owner
> > Run this as SYSDBA.
> Why as SYSDBA?
So that the user has the privileges to run this against any schema.
Paul...
> -g
Received on Thu Feb 19 2009 - 15:53:13 CST