SCN,Log sequence number
what is SCN(system change number),log sequence number.....
how it is useful.....
wt they do...
Thanks and Regards.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Concern what about parv say.
Scn (system change number)—WHAN a transaction is committed a SCN number is generate.
Log sequence number –when a log switch occur than a log sequence number is generated.
Now u ask what the log switch??
So please read the chapter REDO LOG FILE from any oracle 8i,9i,10g database book.
Its easy for u .
Click Here to Expand Forum to Full Width