oracle巡检脚本

1.数据库实例状态
SELECT inst_id, instance_name, host_name, VERSION, TO_CHAR (startup_time, 'yyyy-mm-dd hh24:mi:ss') startup_time, status, archiver, database_status FROM gv$instance;


2数据库打开状态
SELECT inst_id, dbid, NAME, TO_CHAR (created, 'yyyy-mm-dd hh24:mi:ss') created, log_mode, flashback_on ,TO_CHAR (version_time, 'yyyy-mm-dd hh24:mi:ss') version_time,open_mode 
FROM gv$database;


3表空间可用性检查
select tablespace_name,block_size,status,contents,extent_management,segment_space_management from dba_tablespaces


4表空间使用情况检查


select 
  free.tablespace_name ,
  file_count,
  tot.tot_size "total_size(m)",
  free.free_size "free_size(m)",
  100-ceil(free.free_size/tot.tot_size*100) "used_pct(%)",
  ceil(free.free_size/tot.tot_size*100) "free_pct(%)"
from 
(select