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: ============================ 1. I would like to replicate one table from DB1 to DB2 and both the DBs reside on same server. How can I achieve it? 2. My database stats gathering job was automatically stopped. What could be the reason behind it? 3. Lets say PRIMARY db size is 500gb and target db size...
Jan 27, 2020•23 min•Ep. 19
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: ============================ 1. How to choose protection modes in Dataguard environment? 2. What is the difference between count(*) and count(column_name)? 3. Could you please explain cpu tuning parameter on database? 4. My database size is 500 GB and what's the recommended size for FRA ? 5. Does v...
Jan 25, 2020•21 min•Ep. 18
In this episode of daily DBA, I would like to present you with SCAN listener concept inside Oracle RAC and how it functions! - How SCAN works inside Oracle RAC? - #dailyDBA #oracleDatabase #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 ;) - Link to full course: https://dbagene...
Jan 23, 2020•14 min•Ep. 17
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: ============================ 1. How to avoid row lock contention? 2. What is Oracle Read consistency? 3. Could you please explain about FRA and the errors we usually see while initiating backup through FRA? 4. What is buffer cache hit ratio and use of it? 5. What will happen internally while gather...
Jan 22, 2020•25 min•Ep. 16
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! - Questions Picked-up For This Episode: ============================ 1. How flashback works for multi-tenant architecture? Like if I have 2 pdbs named HR and Sales inside a single CDB and I am performing any change/release in either of pdb and due to some failure I need to revert changes to original state, before changes. How will it wor...
Jan 21, 2020•30 min•Ep. 15
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! - Questions Picked-up For This Episode: ============================ 1. Does sorting happens in the DB Buffer cache or PGA in Oracle? 2. How to grant select on all tables of a schema to a user? https://support.dbagenesis.com/knowledge-base/grant-select-on-all-tables-in-a-schema/ 3. What is the difference between Oracle Fusion and Oracle ...
Jan 20, 2020•16 min•Ep. 14
In this episode of daily DBA, I speak about what mistakes DBA are making these days? - #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 ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com...
Jan 18, 2020•26 min•Ep. 13
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: ============================ 1. What are the differences between flashback database and guaranteed restore point? 2. Why do we need to set semaphore setting? How semaphore parameter value is calculated? on what basis it's calculated whether it's based on RAM or what? If it's based on RAM then at ea...
Jan 17, 2020•30 min•Ep. 12
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! - Questions Picked-up For This Episode: ============================ 1. 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? 2. How to fix the plan for an sql in database? 3. How to mining data using redo log files? 4. I generally see ORA-19804: cannot reclaim 6710...
Jan 16, 2020•30 min•Ep. 11
In this episode of daily DBA, I pick up 7 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: ============================ 1. By mistake someone removed online redo logs and cleanup job has cleaned archives and we do not have any database backup scheduled at the server. What are ways to recover database again ? 2. What is the difference between checkpoint and SCN? 3. What is the difference ...
Jan 14, 2020•26 min•Ep. 10
In this episode of daily DBA, I pick up 7 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: ============================ 1. Can we directly move from 12c to 19c or we have to firstly move to 18c and then 19c. 2. What is the impact of IMPDP parameter transform=disable_archive_logging on physical standby? 3. Can we change the redundancy level of asm diskgroup if yes then how? 4. What is the...
Jan 11, 2020•28 min•Ep. 9
In this episode of daily DBA, I pick up 7 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: ============================ 1. When must a DBA plan for performing upgrade of database? 2. Do we need to take separate license for Real time apply. 3. How to improve performance of EXPDP apart from parallel option? 4. User has mistakenly dropped a master table which has millions of records. You ha...
Jan 09, 2020•22 min•Ep. 8
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - 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 ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-admi...
Jan 08, 2020•35 min•Ep. 7
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - 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 ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-admi...
Jan 07, 2020•29 min•Ep. 6
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! #oracle #dba #cloud #dailyDBA 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 ;) Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administra...
Jan 06, 2020•24 min•Ep. 5
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - 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 ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-admi...
Jan 04, 2020•24 min•Ep. 4
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! - #oracle #dba #cloud #dailyDBA - 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 ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-admi...
Jan 03, 2020•24 min•Ep. 3
In this episode of daily DBA, I pick up 10 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - 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 ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-adm...
Jan 02, 2020•32 min•Ep. 2
Welcome to the #dailyDBA show , I am your host Arun Kumar and my goal with this show is to help you become an Oracle Database expert. I personally get so many emails, messages, comments that made me think like what can we do to create a place where I answer all the questions and provide more value that benefits every single DBA. Hence, this show! In this very first episode of #dailyDBA, I will be picking up top 10 questions that I received in Dec 2019 and answering it for you!...
Jan 01, 2020•32 min•Ep. 1
