Dba / Tablespaces - storage
storpct.sql - Occupation des tablespaces, Taux
compute sum of bytes used free on report break on report select a.tablespace_name ts, a.file_id, sum(b.bytes)/count(*) bytes, sum(b.bytes)/count(*) - sum(a.bytes) used, sum(a.bytes) free, nvl(100-(sum(nvl(a.bytes,0))/(sum(nvl(b.bytes,0))/count(*)))*100,0) pct_used from sys.dba_free_space a, sys.dba_data_files b where a.tablespace_name = b.tablespace_name and a.file_id = b.file_id group by a.tablespace_name, a.file_id; clear computes Doc Type: DBA | SubType: Storage | Cible: Tablespaces | Desc: Occupation des tablespaces, Taux | #