SQL 查詢 tablespace
自己組 SQL 來 monitor
SELECT df.tablespace_name TABLESPACE, df.max_space_gb max_space_gb, df.total_space_gb total_space_gb, (df.total_space_gb - fs.free_space_gb) used_space_gb, fs.free_space_gb free_space_gb, ROUND(100 * (fs.free_space_gb / df.total_space_gb), 2) pct_free, ROUND(100 - 100 * (df.total_space_gb - fs.free_space_gb) / df.max_space_gb, 2) pct_max_free FROM (SELECT tablespace_name, ROUND(SUM(DECODE(autoextensible, 'YES', maxbytes, bytes)) / 1073741824, 2) max_space_gb, ROUND(SUM(bytes) / 1073741824, 2) total_space_gb FROM dba_data_files GROUP BY tablespace_name) df, (SELECT tablespace_name, ROUND(SUM(bytes) / 1073741824, 3) free_space_gb FROM dba_free_space GROUP BY tablespace_name) fs WHERE df.tablespace_name = fs.tablespace_name(+) ORDER BY fs.tablespace_name; |