Published On Jan 25, 2020
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!
00:00 Intro
02:24 How to choose protection modes in Dataguard environment?
04:45 What is the difference between count(*) and count(column_name)?
06:40 Could you please explain cpu tuning parameter on database?
09:21 My database size is 500 GB and what's the recommended size for FRA ?
13:10 Does virtual column inside Oracle make query faster?
15:28 DBA Challenge!
Bonus Question
16:34 PL/SQL code taking time to execute on client machine?
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis