DBMS Gather Table Stats | #dailyDBA 16

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

Questions Picked-up For This Episode:

01:17 How to avoid row lock contention?

02:39 #dba Challenge!

03:13 What is Oracle Read consistency?

06:04 Could you please explain about FRA and the errors we usually see while initiating backup through FRA?

12:31 What is buffer cache hit ratio and use of it?

20:10 What will happen internally while gathering table statistics when we execute dbms_stats.gather_table_stats?

Bonus Question
22:53 Which version of the Oracle database would you recommend me to learn whether it is 12c ,11g ,10g,18c 19c?

#dailyDBA #oracleDatabase #cloudDBA #dbaGenesis

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

Start your DBA Journey Today !!


DBMS Gather Table Stats | #dailyDBA 16