 Posted 1/18/2009 3:06:14 PM
|
|
|
|
How can we know how many more redo logs the CAPTURE process has to mine.
Our Capture was down for a week and we brought it up now and want to monitor how many more it has to mine.
Is there any simple query that can give us this?
|
|
|
Posted 1/18/2009 3:06:57 PM
|
|
|
|
You can get the current SCN processing from v$streams_capture.
Then you can check DBA_REGISTERED_ARCHIVE_LOGS to see which logfile contains this SCN, and how many arrived after that point.
|
|
|
|