Re: Tablespace usage for a specific user

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/05
Message-ID: <qLW_4.234626$Tn4.2117435@news1.rdc2.pa.home.com>#1/1

If you mean by schema:

select sum(bytes) from dba_segments where owner='USERNAME' and tablespace_name='TABLESPACE';

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Jan M. Stankovsky" <jan_at_ifs.univie.ac.at> wrote in message
news:393BD90E.B9AA8359_at_ifs.univie.ac.at...


> How can I find out how much space a user is useing in a certain

> tablespace.

>

> tnaks !

Received on Mon Jun 05 2000 - 00:00:00 CDT