| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Determining the disk space used by a schema.
<jayway_at_myrealbox.com> a écrit dans le message de news:
1152828130.852866.71170_at_m79g2000cwm.googlegroups.com...
>
> I'd like to find out how much disk space is being used by one schema my
> Oracle 10g database. My schema is sharing a tablespace with other
> schemas, so I can't just check the size of the tablespace.
>
Run this in your schema
Select sum(bytes)/1024/1024 Mb, tablespace_name
from user_segments
group by tablespace_name;
Received on Thu Jul 13 2006 - 19:55:50 CDT
 |
 |