| SCN Generation [message #59757] |
Sun, 21 December 2003 19:06  |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi,
Can anyone explain me when SCN get generated in DB. I mean is it get generated after COMMIT or after every SQL STATEMENT.
Thanx in advance.
|
|
|
|
| Re: SCN Generation [message #59760 is a reply to message #59757] |
Sun, 21 December 2003 21:46  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Whenever a transaction COMMITs, Oracle assigns a System Change Number (SCN) to the transaction. However, please note that there are many other database events (and SELECT is not one of them) that also increments the SCN.
Execute the following SQL statement to see your database's current SCN value:
SQL> select dbms_flashback.get_system_change_number from dual;
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
