Скачать или смотреть Fix SQL Plan in Oracle |

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

00:00 Intro
02:13 Client is upgrading OS from OEL 6 to OEL 7. They want us to upgrade the DB also from 11g to 12c. How should I proceed further?
09:01 How to fix the plan for an sql in database?
12:46 How to mining data using redo log files?
16:00 I generally see ORA-19804: cannot reclaim 67108864 bytes disk space from 10737418240 bytes limit. Error in all the production database backups. What to do?
17:54 What is use of snapshot controlfile. How rman uses snapshot controlfile with recovery catalog and without recovery catalog.
21:06 Can you please explain about types of protection modes in dataguard and their purpose?
Bonus Question
26:28 What are the prerequisits for becoming a DBA?

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis