Маленькие радости SQLDeveloper'a

Вот как можно приукрасить стандартный отчет об использовании табличных пространств:


Трюк весьма прост:
select tablespace,
'SQLDEV:GAUGE:0:100:0:90:'||to_char(used) usage,
allocated_mb,
used_mb,
free_mb,
used,
data_files from (
select nvl(b.tablespace_name,
nvl(a.tablespace_name,'UNKNOWN')) Tablespace,
kbytes_alloc Allocated_MB,
kbytes_alloc-nvl(kbytes_free,0) Used_MB,
nvl(kbytes_free,0) Free_MB,
round(((kbytes_alloc-nvl(kbytes_free,0))/kbytes_alloc)*100,2) Used,
data_files Data_Files
from ( select sum(bytes)/1024/1024 Kbytes_free,
max(bytes)/1024/1024 largest,
tablespace_name
from sys.dba_free_space
group by tablespace_name ) a,
( select sum(bytes)/1024/1024 Kbytes_alloc,
tablespace_name,
count(*) data_files
from sys.dba_data_files
group by tablespace_name )b
where a.tablespace_name (+) = b.tablespace_name
)
order by 1