Oracle Database Health Check

DBA Health Check

clear buffer;

set heading on
set verify off
set feed off
set linesize 80
set pagesize 1000
set underline '='
set serveroutput on size 100000

col dtime format a30 heading '1. Report started at Date/Time' ;
select to_char(sysdate, 'DD/MON/RRRR HH24:MI:SS') dtime from dual;

col db format a9 heading 'DB Name';
col created format a9 heading 'Created';

select
  name db
, created
from V$DATABASE;

col ver format a64 heading '2. Oracle RDBMS/Tools Version(s)';

prompt
prompt 2. Oracle Version(s) :
select
  banner ver
from V$VERSION;