INACTIVE Session Blocking ACTIVE Session | dailyDBA 49 - a podcast by Arun Kumar

from 2020-06-27T14:30

:: ::

Questions Picked for the Episode

What is the use of Locks inside database? Why can't we use the database without locks?

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?

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.

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?

How to find performance bottleneck of a query?

#oracle #dbagenesis #performanceTuning

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 ;)

Link to all DBA courses: https://dbagenesis.com/courses

Link to real-time projects: https://dbagenesis.com/p/projects

Link to support articles: https://support.dbagenesis.com

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!!

DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.

Facebook: https://www.facebook.com/dbagenesis/

Instagram: https://www.instagram.com/dbagenesis/

Twitter: https://twitter.com/DbaGenesis

Website: https://dbagenesis.com/

Start your DBA Journey Today !!

Further episodes of DBA Genesis Audio Experience

Further podcasts by Arun Kumar

Website of Arun Kumar