Read consistency and query SCN
Hello Everybody,
From documentation about Read consistency:
As a query enters the execution stage, the current system change number (SCN) is determined. As data blocks are read on behalf of the query, only blocks written with the observed SCN are used. Blocks with changed data (more recent SCNs) are reconstructed from data in the rollback segments, and the reconstructed data is returned for the query.
Is there a way to identify this SCN (the current SCN when the query entered execution phase) for a running or a completed query?
Thanks
From documentation about Read consistency:
As a query enters the execution stage, the current system change number (SCN) is determined. As data blocks are read on behalf of the query, only blocks written with the observed SCN are used. Blocks with changed data (more recent SCNs) are reconstructed from data in the rollback segments, and the reconstructed data is returned for the query.
Is there a way to identify this SCN (the current SCN when the query entered execution phase) for a running or a completed query?
Thanks
0