V$LOG_HISTORY

This view shows the log history from the control file.

Fields

The most relevant view fields are:

  • RECID: The control file record ID
  • STAMP: The control file record stamp
  • THREAD#: The thread number of the archived log
  • SEQUENCE#: The sequence number of the archived log
  • FIRST_CHANGE#: The lowest system change number in the log
  • FIRST_TIME: The time of the first entry in the log
  • NEXT_CHANGE#: The highest system change number in the log
  • RESETLOGS_CHANGE#: The resetlogs change number of the database when the log was written
  • RESETLOGS_TIME: The resetlogs time of the database when the log was written

See also

  • The V$LOG and V$LOGFILE sections in this appendix

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial