dba_free_space

From: Ariel Kirson <arielk_at_exlibris.co.il>
Date: Sun, 03 May 1998 17:07:29 +0300
Message-ID: <354C7A21.BB79EB4B_at_exlibris.co.il>

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

[Quoted] Hello all,

Our company has been using the following query to find out how much free space is available for each tablespace in our database :

select sum(BYTES)/1024
from DBA_FREE_SPACE
where TABLESPACE_NAME = 'TS0';

I am trying to find out how much space is used and how much is free for each USER defined in the database. Any ideas on how I can do this ?

Thanks in advance,

Ariel Kirson
Ex Libris.

--------------498D82492D0EDDF14EA07F12

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ariel Kirson
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Ariel Kirson
n:              Kirson;Ariel
org:            Ex Libris
adr:            ;;;Jerusalem;;;ISRAEL
email;internet: arielk_at_exlibris.co.il
tel;work:       972-2-6798222 (ext. 161)
tel;home:       972-2-6428250

x-mozilla-cpt: ;0
x-mozilla-html: FALSE

version:        2.1
end:            vcard

--------------498D82492D0EDDF14EA07F12--
Received on Sun May 03 1998 - 16:07:29 CEST