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:

02:07 What would you recommend as a DBA either to use sql profiles by sql tuning set or fixing plan by using sql plan management?

03:17 Why we put database in MOUNT RESTRICT mode before dropping database?

03:57 Can you explain SQL tuning advisor how to run and how to analyze it?

05:14 Difference between integrated capture and classic capture in golden gate? In integrated capture do we need to create the logminer database in source database or Oracle uses logminer mechanism?

07:53 What is virtual IP (HAIP) and how it is different from normal IP?
12:12 #dba Challenge!

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

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

#virtual ip #vip

What is Virtual IP (VIP) | #dailyDBA 22
1.25 GEEK