V$LOG_HISTORY

An entry for each Log Switch that has occured.

Columns
   ___________________________
 
   RECID
   STAMP
   THREAD#
   SEQUENCE#
   FIRST_CHANGE#
   FIRST_TIME
   NEXT_CHANGE#

A script to list the history of log switches per hour over the last week.

Related:

V$LOG 
V$LOGFILE 
V$LOGHIST 


 
Copyright © SS64.com 1999-2019
Some rights reserved