FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / Oracle Streams Replication / Streams Capture Down for a Week! / Latest PostsInstantForum.NET v4.1.4FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionalshttp://www.franklinfaces.com/no-reply@FranklinFaces.comThu, 09 Feb 2012 11:07:09 GMT20RE: Streams Capture Down for a Week!http://www.franklinfaces.com/Topic71-58-1.aspxYou can get the current SCN processing from v$streams_capture.<br><br>Then you can check DBA_REGISTERED_ARCHIVE_LOGS to see which logfile contains this SCN, and how many arrived after that point.Sun, 18 Jan 2009 15:06:57 GMTAdminStreams Capture Down for a Week!http://www.franklinfaces.com/Topic71-58-1.aspxHow can we know how many more redo logs the CAPTURE process has to mine.<br><br>Our Capture was down for a week and we brought it up now and want to monitor how many more it has to mine.<br><br>Is there any simple query that can give us this?<br><br>Sun, 18 Jan 2009 15:06:14 GMTAdmin