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

DBMS Gather Table Stats | #dailyDBA 16