论坛 › Oracle运维 › Oracle数据库管理员职责（一）

56gt 发表于 2018-9-24 15:15:08

Oracle数据库管理员职责（一）

SELECT tablespace_name, max_m, count_blocks free_blk_cnt, sum_free_m,to_char(100*sum_free_m/sum_m, '99.99') || '%' AS pct_free　　FROM (SELECT tablespace_name,sum(bytes)/1024/1024 AS sum_m
　　FROM dba_data_files
　　GROUP BY tablespace_name),
　　(SELECT tablespace_name AS fs_ts_name, max(bytes)/1024/1024 AS max_m, count(blocks) AS count_blocks, sum(bytes/1024/1024) AS sum_free_m
　　FROM dba_free_space
　　GROUP BY tablespace_name )
　　WHERE tablespace_name = fs_ts_name;

查看完整版本: Oracle数据库管理员职责（一）