ckloghist.sql

REM *************************************************************************** 
REM 
REM        TITLE:
REM        AUTHOR:
REM        DESCRIPTION:
REM
REM
REM
REM        USAGE W/ PARAMETERS:
REM        
REM        TABLES USED:
REM
REM  MODIFICATION ALLOWED (Y/N):	
REM  MODIFICATION HISTORY:
REM  WHO          WHEN         WHAT
REM  --------------------------------------------------------------------------
REM               MM/DD/YY     INITIAL CREATION
REM
REM ***************************************************************************
set linesize 140
set pagesize  50
set echo off;

PROMPT
PROMPT **** CHECK DATABASE LOGS ****
PROMPT

SELECT 
 	THREAD#,
 	SEQUENCE#, 
 	FIRST_CHANGE#, 
 	FIRST_TIME,
        SWITCH_CHANGE# 
  FROM  V$LOGHIST;