<p>Questions Picked for the Episode</p> <p><br></p> <p>What is the use of Locks inside database? Why can't we use the database without locks?</p> <p><br></p> <p>Our reporting team directly works on production database and my client is insisting to give a dedicated database which will act as copy of production database. What are my options?</p> <p><br></p> <p>In one of the interviews, I was asked "In what scenario an INACTIVE session will BLOCK an active session". I really don't know the answer.</p> <p><br></p> <p>Every-time my team performs export and import, they have to drop the constraints and indexes. Post import is done, we re-create the constraints and indexes. Is there any simple method for same?</p> <p><br></p> <p>How to find performance bottleneck of a query?</p> <p>-</p> <p>#oracle #dbagenesis #performanceTuning</p> <p>-</p> <p>Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)</p> <p>-</p> <p>Link to all DBA courses: https://dbagenesis.com/courses</p> <p>Link to real-time projects: https://dbagenesis.com/p/projects</p> <p>Link to support articles: https://support.dbagenesis.com</p> <p>-</p> <p>DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!!</p> <p><br></p> <p>DBA Genesis is currently the fastest &amp; the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.</p> <p>-</p> <p>Facebook: https://www.facebook.com/dbagenesis/</p> <p>Instagram: https://www.instagram.com/dbagenesis/</p> <p>Twitter: https://twitter.com/DbaGenesis</p> <p>Website: https://dbagenesis.com/</p> <p>Contact us: https://dbagenesis.com/p/contact</p> <p>-</p> <p>Start your DBA Journey Today !!</p>

DBA Genesis Audio Experience

Arun Kumar

INACTIVE Session Blocking ACTIVE Session | dailyDBA 49

JUN 27, 202020 MIN
DBA Genesis Audio Experience

INACTIVE Session Blocking ACTIVE Session | dailyDBA 49

JUN 27, 202020 MIN

Description

<p>Questions Picked for the Episode</p> <p><br></p> <p>What is the use of Locks inside database? Why can't we use the database without locks?</p> <p><br></p> <p>Our reporting team directly works on production database and my client is insisting to give a dedicated database which will act as copy of production database. What are my options?</p> <p><br></p> <p>In one of the interviews, I was asked "In what scenario an INACTIVE session will BLOCK an active session". I really don't know the answer.</p> <p><br></p> <p>Every-time my team performs export and import, they have to drop the constraints and indexes. Post import is done, we re-create the constraints and indexes. Is there any simple method for same?</p> <p><br></p> <p>How to find performance bottleneck of a query?</p> <p>-</p> <p>#oracle #dbagenesis #performanceTuning</p> <p>-</p> <p>Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)</p> <p>-</p> <p>Link to all DBA courses: https://dbagenesis.com/courses</p> <p>Link to real-time projects: https://dbagenesis.com/p/projects</p> <p>Link to support articles: https://support.dbagenesis.com</p> <p>-</p> <p>DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!!</p> <p><br></p> <p>DBA Genesis is currently the fastest &amp; the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.</p> <p>-</p> <p>Facebook: https://www.facebook.com/dbagenesis/</p> <p>Instagram: https://www.instagram.com/dbagenesis/</p> <p>Twitter: https://twitter.com/DbaGenesis</p> <p>Website: https://dbagenesis.com/</p> <p>Contact us: https://dbagenesis.com/p/contact</p> <p>-</p> <p>Start your DBA Journey Today !!</p>