/* ************************************************************* */
REM * @c:\oracle\sql\chkpnt_1.sql                                *
REM *                                                            *
REM * Owner: R.Kupcunas                                          *
REM * Date:  01-MAY-95                                           *
REM * FUNCTION:  reports checkpoint related system statistics    */
/* ************************************************************* */
REM
REM file: chkpoint.sql      
REM function: reports checkpoint related system statistics
REM called by:  bm_driver.sql  

spool chkpnt_1.rslt;

col name format a40
col value format 9999999999
set pause off
set pages 0
set newpage 0
set feedback off
set verify off
set echo off

select 'chkpoint',
           nvl(a.value,0), nvl(b.value,0), nvl(c.value,0)
from v$sysstat a, 
         v$sysstat b,
         v$sysstat c
where a.name = 'DBWR checkpoints' and
           b.name = 'background checkpoints completed' and
           c.name = 'background checkpoints started';

spool off;
commit;
