Re: How to determine oracle user size?(B

From: Ram(B <krishna000_at_gmail.com>
Date: Wed, 18 Feb 2009 20:47:23 -0800 (PST)
Message-ID: <e8ade7f6-e6f1-45b3-a197-1ac660a9249a_at_t39g2000prh.googlegroups.com>

On Feb 19, 7:15 am, Ming$BGl(B <l..._at_tech-trans.com> wrote:
> Hi
>
> Any SQL statement can find the Oracle user/owner size when more than
> one user in a Oracle instance? Thx!
>
> Ming

Hi,

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

Regards

RAM Received on Wed Feb 18 2009 - 22:47:23 CST