HomeОбразованиеRelated VideosMore From: Ramkumar Swaminathan

System Change Number in Oracle Database - SCN - DBArch Video 26

31 ratings | 4511 views
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Html code for embedding videos on your blog
Text Comments (11)
Syeda Munawar Fatima (1 month ago)
Sir in the instance recovery video u said that rollforward happens with the committed un-checkpointed changes in the redo log.and roll back happens with the uncommited uncheckpointed changes ...Here u are saying rollforward happens with the not committed changes????Please clear...
Syeda Munawar Fatima (1 month ago)
+Ramkumar Swaminathan Thank you so much for your prompt reply..You are great sir...Not only I am watching your videos but also enjoying them a lot...
Ramkumar Swaminathan (1 month ago)
Rollforward is for committed transactions only...
Anand Parthasarathy (1 month ago)
How about if the DB is IDLE, Will it change or not?
Ramkumar Swaminathan (1 month ago)
ACtually SCN is generated continuously based on timestamp ( Thats my understanding)... checkpoints that happen automatically uses that to synchronize file headers...
sachin tiwari (2 months ago)
Okk
sachin tiwari (2 months ago)
Sir in multi transaction vedio u said that SCN is only generate when commit is occur In this vedio u saying that if any event occure like dml,ddl, select then scn is generate.
Ramkumar Swaminathan (2 months ago)
SCN is generated for every change.. but only on commit it gets committed for the transaction
sagar jagtap (9 months ago)
nice1 sir
Ramkumar Swaminathan (9 months ago)
Thanks
Thank you sir

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.