Dear All,
I am having some doubts regarding the System Change
Number(SCN):
1. What is the minumum and maximum value of SCN?.
2. What will happen if the SCN reaches the maximum value ?. If it gets resetted to 0(or minimum), then how the read-consistency is maintained ?. Oracle determines the read-consistency and take the data for SQL queries from rollback segments based on the SCN value and hence how that mechanism works in this situation.