Re: [Q] how to check total space a user allocate ?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 23 Oct 2002 19:26:13 +0200
Message-ID: <0qmdrus20g21he30k3o1uao2fk4d0ktk1p@4ax.com>

On 23 Oct 2002 07:53:33 -0700, aaa <leed_at_shell.cais.com> wrote:

>We have ORACLE 8.1.7 on SUN server. Does anyone has script that can ckeck
>how many total space a user allocate on oracle?
>
>
>Thanks.

Actually in this particular case posting the question requires more typing than doing it yourself. Is this homework or what, or are you really lazy?

select owner, sum(bytes)
from dba_segments
group by owner

is all you need.
What's so difficult about that?

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 23 2002 - 12:26:13 CDT