Fix SQL Plan in Oracle | скачать в хорошем качестве

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