V$ARCHIVE_PROCESSES

V$LOGMNR_PARAMETERS

This view contains log information.

[@more@]

V$LOGMNR_PARAMETERS

This view contains log information.

Column	Datatype	Description
START_DATE	DATE	The date to start search at
END_DATE	DATE	The date to end search at
START_SCN	NUMBER	The system change number to start search
END_SCN	NUMBER	The system change number to end search
INFO	VARCHAR2(32)	An informational message
STATUS	NUMBER	The status. A NULL value indicates parameters are valid. A non-NULL value indicates further information is contained in the INFO column as a text string.

说明：这个视图里面的信息是前一次logmnr时候的分析参数，主要包括日志查找的开始时间，终止时间，日志查找的开始scm号，终止scn号。

V$LOGMNR_LOGS

This view contains log information.

Column	Datatype	Description
LOG_ID	NUMBER	Log file identifier
FILENAME	VARCHAR2(513)	Name of the log file
LOW_TIME	DATE	Oldest date of any records in the file
HIGH_TIME	DATE	Most recent date of any records in the file
DB_ID	NUMBER	Database ID
DB_NAME	VARCHAR2(8)	Name of the database
RESET_SCN	NUMBER	Reset log SCN when the log was created
RESET_SCN_TIME	DATE	Time when the reset log SCN was obtained to create the log
THREAD_ID	NUMBER	Thread number
THREAD_SQN	NUMBER	Thread sequence number
LOW_SCN	NUMBER	SCN allocated when log switched into
NEXT_SCN	NUMBER	SCN after this log. Low SCN of the next log.
INFO	VARCHAR2(32)	Informational message. A value of MISSING_LOGFILE will be assigned to a row entry where a needed logfile is missing from the list of log files.
STATUS	NUMBER	Indicates the status of a logfile. A NULL value indicates a valid logfile; a non-NULL value indicates further information is contained in the INFO column as a text string. All logfiles successfully added to the file list will have a status value of NULL.

说明：

1， 其中的RESET_SCN和RESET_SCN_TIME是上一次重置日志的时间。如果未进行过不完全恢复那么这个时间和scn就是数据库创建的时间和scn号；如果进行过不完全恢复那么这个时间和scn号就是上次恢复后的时间和scn号。

V$LOGMNR_DICTIONARY

This view contains log history information.

Column	Datatype	Description
TIMESTAMP	DATE	Date the dictionary was created
DB_ID	NUMBER	Database ID
DB_NAME	VARCHAR2(8)	Name of the database
FILENAME	VARCHAR2(513)	Dictionary filename
DICTIONARY_SCN	NUMBER	System change number when the dictionary was created
RESET_SCN	NUMBER	Reset log SCN when the dictionary was created
RESET_SCN_TIME	DATE	Time when the reset log SCN was obtained to create the dictionary
ENABLED_THREAD_MAP	RAW(16)	Bit map of currently enabled threads when the dictionary was created
INFO	VARCHAR2(32)	Informational/Status message BAD_DATE indicates that the SCN of the dictionary file does not match the SCN range of the log files
STATUS	NUMBER	A NULL indicates a valid dictionary file for the list of log files. A non-NULL value indicates further information is contained in the INFO column as a text string.

V$LOGMNR_CONTENTS

This view contains log history information.

When a SELECT statement is executed against the V$LOGMNR_CONTENTS view, the archive redo log files are read sequentially. Translated records from the redo log files are returned as rows in the V$LOGMNR_CONTENTS view. This continues until either the filter criteria specified at startup (EndTime or endScn) are met or the end of the archive log file is reached.

Column	Datatype	Description
SCN	NUMBER	System change number (SCN) when the redo record was generated
CSCN	NUMBER	Commit scn
TIMESTAMP	DATE	Timestamp
COMMIT_TIMESTAMP	DATE
THREAD#	NUMBER	Number of the thread which generated the redo record
LOG_ID	NUMBER	Number of the log file which contains the redo record. This number is generated by LogMiner to uniquely identify a log, and corresponds to the LOG_ID column in V$LOGMNR_FILES.
XIDUSN	NUMBER	Transaction ID undo segment number of the transaction which generated the change
XIDSLT	NUMBER	Transaction ID slot number of the transaction which generated the change
XIDSQN	NUMBER	Transaction ID sequence number of the transaction which generated the change
RBASQN	NUMBER	RBA sequence number of the log that contained this redo record
RBABLK	NUMBER	RBA block number within the log file
RBABYTE	NUMBER	RBA byte offset within the block
UBAFIL	NUMBER	UBA file number identifying the file containing the undo block
UBABLK	NUMBER	UBA block number for the undo block
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8394333/viewspace-987132/，如需转载，请注明出处，否则将追究法律责任。 0 0 分享到： 上一篇： v$log 下一篇： v$mystat 请登录后发表评论 登录 全部评论 <%=items[i].createtime%> <%=items[i].content%> <%if(items[i].items.items.length) { %> <%for(var j=0;j <%=items[i].items.items[j].createtime%> 回复 <%=items[i].items.items[j].username%>   回复   <%=items[i].items.items[j].tousername%>： <%=items[i].items.items[j].content%> <%}%> <%if(items[i].items.total > 5) { %> 还有<%=items[i].items.total-5%>条评论 ) data-count=1 data-flag=true>点击查看 <%}%> <%}%> <%}%> sunwgneuqsoft 博文量 56 访问量 758256 最新文章 10g新特性——Data Pump(转) 10g新特性——表空间重命名 10g新特性——回滚监视 10g新特性——闪回版本查询 cbo心得(选择率,基数,直方图)(五) cbo心得(选择率,基数,直方图)(四) cbo心得(选择率,基数,直方图)(三) cbo心得(选择率,基数,直方图)(二) cbo心得(选择率,基数,直方图)(一) oracle的学习方法——关于测试的两点体会 支持我们 作者招募 用户协议 FAQ Contact Us 北京盛拓优讯信息技术有限公司. 版权所有  京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号：11010802021510 广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

转载于:http://blog.itpub.net/8394333/viewspace-987132/