How to Retrieve the Current SCN
Under an Oracle session in Oracle10g, I want to retrieve the SCN value for each transaction or request.
For a logical transaction involving any row change or row lock, it implies the start of a logical transaction. It is possible to retrieve the current SCN value from V$TRANSACTION view.
But for a request purely involving SQL statements only, it cannot refer to V$TRANSACTION view.
Will a unique SCN be assigned for SQL statement execution? If yes, how to get the SCN value?
If a session continually execute several SQL statements, does it use the same SCN while SQL execution?