oracle巡检语句

最新推荐文章于 2024-05-16 15:29:20 发布

老帽爬新坡

最新推荐文章于 2024-05-16 15:29:20 发布

阅读量109

点赞数

文章标签： oracle 数据库 dba

原文链接：http://blog.chinaunix.net/uid-25356953-id-4637107.html

版权

select * from v$controlfile;
select * from v$logfile;
select tablespace_name ,status from dba_tablespaces;
select file_name,status from dba_data_files;
SELECT df.tablespace_name, COUNT (*) datafile_count,
ROUND (SUM (df.BYTES) / 1048576) size_mb,
ROUND (SUM (free.BYTES) / 1048576, 2) free_mb,
ROUND (SUM (df.BYTES) / 1048576 - SUM (free.BYTES) / 1048576, 2 ) used_mb,
ROUND (MAX (free.maxbytes) / 1048576, 2) maxfree,
100 - ROUND (100.0 * SUM (free.BYTES) / SUM (df.BYTES), 2) pct_used,
ROUND (100.0 * SUM (free.BYTES) / SUM (df.BYTES), 2) pct_free
FROM dba_data_files df,
(SELECT tablespace_name, file_id, SUM (BYTES) BYTES, MAX (BYTES) maxbytes FROM dba_free_space GROUP BY tablespace_name, file_id) free
WHERE df.tablespace_name = free.tablespace_name(+) AND df.file_id = free.file_id(+)
GROUP BY df.tablespace_name