on 06-24-2011 2:43 PM
Dear experts,
Could you please let me know what is the difference between the SCN and the log switches in Oracle?
Thanks and regards
Rodolfo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry but ...
[http://lmgtfy.com/?q=oraclescnsavepoint]
[http://lmgtfy.com/?q=oraclescnlog switch]
regards,
Lars
SCN (System change number) to identify a moment in database.
Log switch: is nothing but DB complete wirting to one redo log file starts writing to next available log.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.