Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Free space by tablespace script, quality control check.
For anybody who cares there was a bug in the script, here is fixed version.
select
tablespace_name,
round(sum(total_mb)-sum(free_mb)) cur_use_mb, round(sum(total_mb)) cur_sz_mb, round((sum(total_mb)-sum(free_mb))/sum(total_mb)*100) cur_percent_full, round(sum(max_mb) - (sum(total_mb)-sum(free_mb))) free_space_mb, round(sum(max_mb)) max_sz_mb, round((sum(total_mb)-sum(free_mb))/sum(max_mb)*100) overall_percent_fullfrom
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Jun 27 2000 - 00:00:00 CDT