Hello Sir, Your simple explanation is very helpful in learning and getting a good understanding of the Oracle DB. It is good if you provide examples also with the same and also please publish some video on oracle performance tuning topic like loops, hints, direct path load ,conventional path load.
Hi Mohith, thanks for your feedback. I already have a playlist on Performance and am working on creating more videos on that. Please go through them... will keep them updated...
Sir I have a doubt the very basic why do the different users want to access the same dat, in what circumstances i happens? I can understand about the access of < same user different sessions> but could not get about the access of .....
Syeda Munawar Fatima two users executing same block of code within the application ( there by two different sessions by two different users via piece of software code block ) … second user’s update may have changed state of data before first user’s update. With transaction consistency first user update will fail as second user changed data. First users SCN finds change in original state and gives error. … Suresh
Thank you Sir
Thank you
nice explanation sir
Hello Sir, Your simple explanation is very helpful in learning and getting a good understanding of the Oracle DB. It is good if you provide examples also with the same and also please publish some video on oracle performance tuning topic like loops, hints, direct path load ,conventional path load.
Hi Mohith, thanks for your feedback. I already have a playlist on Performance and am working on creating more videos on that. Please go through them... will keep them updated...
excellent sir..
Enjoy learning
Sir I have a doubt the very basic why do the different users want to access the same dat, in what circumstances i happens? I can understand about the access of < same user different sessions> but could not get about the access of .....
That will depend on the application logic....
Syeda Munawar Fatima two users executing same block of code within the application ( there by two different sessions by two different users via piece of software code block ) … second user’s update may have changed state of data before first user’s update. With transaction consistency first user update will fail as second user changed data. First users SCN finds change in original state and gives error. … Suresh