Follow me: ---------- LinkedIn: www.linkedin.com/in/atsohmofor/ Twitter: twitter.com/Bindag OR @Bindag email: bobsukki@gmail.com Telegram: NI TSOH UA-cam: ua-cam.com/channels/x06.html... OR NI TSOH
Hi Sir...Thanks for the nice video.. i have one query which has been asked in an interview.... question--there is a table which is having huge rows and DML operations is going on that table ..at the same time , you need to add couple of columns on that table ..how will you do that ?
Well the enqueue mechanism will continue to manage the locks as they are acquired and released. If DML already acquired the lock, no structural change to table can be made until DML completes (commits or rolls back). Alter table statement will hang until DML completes. Hope that helps.
Since these are simple statements, would you be able to just follow and copy onto your SQL prompt? Unfortunately, I did not include these in the transcript
Follow me:
----------
LinkedIn: www.linkedin.com/in/atsohmofor/
Twitter: twitter.com/Bindag
OR @Bindag
email: bobsukki@gmail.com
Telegram: NI TSOH
UA-cam: ua-cam.com/channels/x06.html... OR NI TSOH
I do not remember blocking sessions explained so eloquently. Thank you for the great video!
Wow, thank you. I am happy I provided another perspective 👍🏾
@@bobsukki Indeed! Thank you
This is a must have in any Dba’s liked videos on here, well explained… performance tuning made simple. 👍
Absolutely! Thank you for such a great recommendation 🙏🏽
Top Notch!! A well structured, educative video with a hands-on activity on row lock contention that is as good as you can get. Great work Atsoh!
Much appreciated! Thank you 🙏
Agreed!
Great content, I have been waiting on a video that deals with Database Performance. Thank you for making one!
I am glad you like it. I plan on addressing more performance related concepts. Thank you
very nicely explained and very much informative
Glad it was helpful!
Great and thanks for sharing
Absolutely. Thank you
Excellent vidéo ✅
Thank you Alberto 🙏
Please do more videos on performance tuning, execution plan and sql tuning.
Thanks sir
Sure 👍
Hi Sir...Thanks for the nice video..
i have one query which has been asked in an interview....
question--there is a table which is having huge rows and DML operations is going on that table ..at the same time , you need to add couple of columns on that table ..how will you do that ?
Well the enqueue mechanism will continue to manage the locks as they are acquired and released. If DML already acquired the lock, no structural change to table can be made until DML completes (commits or rolls back). Alter table statement will hang until DML completes. Hope that helps.
Can you paste the sql statements on here somewhere
Since these are simple statements, would you be able to just follow and copy onto your SQL prompt? Unfortunately, I did not include these in the transcript
Could you please paste those sql statements here sir
Did he paste those SQL statements on here?