Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tools for estimate an Oracle database volume
Try this SQL - It gives you a space report by owners,tablespace and type!!!
select substr(owner,1,20) owner, substr(tablespace_name,1,15) tablespace_name, substr(segment_type,1,15) segment_type, sum(bytes) bytes
group by substr(owner,1,20), substr(tablespace_name,1,15), substr(segment_type,1,15)
Sunil Jayasinghe
DBA
E-mail: sunil.jayasinghe_at_probanka.si
David FAURE wrote in article <01bc9d8f$aa9aff20$420101c0_at_dfa>...
>I wanna find a tool wich can estimate the (future) size of an Oracle
>database.
>From an installed database, we'd like to know the actual size (empty) and
>estimate the size of this database in the future according to the
estimate
>number of records.
>Where can i find this.
>Thanks
>
>David
>
>
Received on Thu Jul 31 1997 - 00:00:00 CDT