Change this parameter only when it is absolutely necessary to see the most current version of the database when doing a query. This initialization parameter should not be changed except under a limited set of circumstances specific to the Oracle Parallel Server. It determines whether the local SCN should be refreshed from the lock value when getting the snapshot SCN for a query.
Units are in hundredths of seconds.
Under very unusual circumstances involving rapid updates and queries of the same data from different instances, the SCN might not be refreshed in a timely manner. Setting the parameter to zero causes the SCN to be refreshed immediately after a commit. All Rights Reserved.