eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_LOGSTDBY_HISTORY

Object Details

Object Name:	DBA_LOGSTDBY_HISTORY
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information on processed, active, and pending log streams

[View Source]

Columns

Name	Datatype	Length	Comments
STREAM_SEQUENCE#	NUMBER		Log Stream Identifier
STATUS	VARCHAR2	(16)	The processing status of this log stream
SOURCE	VARCHAR2	(5)	How the logstream was started
DBID	NUMBER		The dbid of the logfile provider
FIRST_CHANGE#	NUMBER		The starting scn for this log stream
LAST_CHANGE#	NUMBER		The scn of the last committed transaction
FIRST_TIME	DATE		The time associated with first_change#
LAST_TIME	DATE		The time associated with last_change#
DGNAME	VARCHAR2	(255)	The Dataguard name
MERGE_CHANGE#	NUMBER		The scn up to and including which was consistent during terminal apply
PROCESSED_CHANGE#	NUMBER		The scn up to which all transactions have been processed

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STREAM_SEQUENCE#
,      STATUS
,      SOURCE
,      DBID
,      FIRST_CHANGE#
,      LAST_CHANGE#
,      FIRST_TIME
,      LAST_TIME
,      DGNAME
,      MERGE_CHANGE#
,      PROCESSED_CHANGE#
FROM SYS.DBA_LOGSTDBY_HISTORY;

Dependencies

[top of page]

SYS.DBA_LOGSTDBY_HISTORY references the following:

SYSTEM: LOGSTDBY$HISTORY

SYS.DBA_LOGSTDBY_HISTORY is referenced by following:

PUBLIC: DBA_LOGSTDBY_HISTORY