Queries on V$archived log

[Satish]

Dear erman

I have gone though many oracle document but it was not clear to me. Could you please update us what is the first_change# and next_change# in v$archived_log

Thanks for all the Support

[ErmanArslansOracleBlog]

first_change# and next_change# are related with the SCN.

first_change# is the lowest SCN that appears in that archived log.
next_change# is the lowest SCN that appears in the next archived log.

So let's suppose, archivelog x 'sfirst_change# = 1
So let's suppose, archivelog x 's next_change# = 11

This means all the changes that are done from SCN 1 to 10(including 10) is in archivelog x.

[Satish]

Thanks a lot erman