ORACLE dba health check script
spool dbhealth.txt set feedback off; set pagesize 0; Select (SELECT NAME FROM V$DATABASE) ||'_Oracle_Database_Health_Report: '||to_char(sysdate,'Mon dd yyyy hh24:mi:ss') "TIMESTAMP" from dual; prompt**=====================================================================================================** prompt** **Database Current Status** prompt**=====================================================================================================** set pagesize 50; set line 300; col HOST_NAME FORMAT a12; col "HOST_ADDRESS" FORMAT a15; col RESETLOGS_TIME FORMAT a12; col "DB RAC?" FORMAT A8; col days format 9999; select name INSTANCE,HOST_NAME, UTL_INADDR.GET_HOST_ADDRESS "HOST_ADDRESS", LOGINS, archiver,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB_UP_TIME", RESETLOGS_TIME "RESET_TIME", FLOOR(sysdate-startup_time) days, (select DECODE(vp1.value,'TRUE','Yes (&