DBA Genesis Audio Experience

DBA Genesis Audio Experience

By Arun Kumar
DBA Genesis is the leading platform for Database Administrators which provides Courses, Online Trainings and Real-Time DBA projects.

In addition to above, DBA Genesis also provides remote DBA support and remote cloud DBA support to clients across the globe.

DBA Genesis is a highly sought after corporate training platform. With over 50,000+ followers and a vision to provide simplified database learning, our goal is to reach every single DBA on this planet by 2025!
Where to listen
Breaker Logo
Google Podcasts Logo
Overcast Logo
Pocket Casts Logo
RadioPublic Logo
Spotify Logo
Define Oracle Instance Size | #dailyDBA 12
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 each time of RAM upgrade will the semaphore settings will be changed? --> https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwaix/tuning-semaphore-parameters.html 3. You have fresh server with 64GB of RAM and you are asked to install 4 db’s in that server how will u allocate the ram for each DB. How is this calculation done? 4. If your not using active dataguard configuration if Block corrupted on standby how will recover corrupted block on standby 5. While recovering corrupted block manually i.e BLOCKRECOVER DATAFILE 2 BLOCK 13; could you please help on what happens internally, like from where oracle gets the original block? - #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/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
29:42
January 17, 2020
Fix SQL Plan in Oracle | #dailyDBA 11
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 67108864 bytes disk space from 10737418240 bytes limit. Error in all the production database backups. What to do? 5. What is use of snapshot controlfile. How rman uses snapshot controlfile with recovery catalog and without recovery catalog. 6. Can you please explain about types of protection modes in dataguard and their purpose? - #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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
30:01
January 16, 2020
Three SCAN IPs Resolving 8 Node RAC | #dailyDBA 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. 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 between local and dictionary tablespace? 4. I want to clone database from source to Target but there is no connectivity between servers. How will clone happen with out connectivity and could you please share high level steps? 5. Can you explain how 3 scan IPs resolve 8 node RAC in Oracle because we have 8 nodes in the cluster and only 3 scan IPs. How is it possible to resolve these 8 nodes? 6. Oracle DB has OMF. someone deleted all the control files. OS -Oracle Linux 7, DB 12c and OS already restarted. Archive log mode is not enabled. Without using the RMAN how to recover the database? - #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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
26:08
January 14, 2020
When to go for Full Table Scan? | #dailyDBA 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. 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 meaning of resolving gap using primary incremental backup? 5. Some of the DBAs say full table scan is better than index scan. Could you please clarify in which situations its better? 6. Why I'm missing AWR snapshot? Once I restarted the DB its started to generate the AWR snapshot? - #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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
27:48
January 11, 2020
Improve EXPDP Performance | #dailyDBA 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! - 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 have only few minutes say 15 to 30 min left for the database to go public. In this scenario, how to bring back the table? Flashback is disabled. 5. Which is the most stable version in Oracle for upgrade? 6. What will happen if we upgrade from 11.2.0.4 to 18c and keep compatible parameter still 11.2.0.4? Bonus: In your experience, I would like to know what are the disadvantages of Oracle database! - #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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
22:23
January 9, 2020
Row Chaining in Oracle | #dailyDBA 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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
35:25
January 8, 2020
How to Add Diskgroup in ASM | #dailyDBA 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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
28:31
January 7, 2020
Which Cloud Platform is Best | #dailyDBA 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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com 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. Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com Start your DBA Journey Today !!
24:10
January 6, 2020
Rebuild Indexes Faster in Oracle | #dailyDBA 4
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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
24:20
January 4, 2020
DBAs Losing Job due to Cloud | #dailyDBA 3
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-administration  Link to all DBA courses: https://dbagenesis.com/courses  Link to real-time projects: https://dbagenesis.com/p/projects  Link to support articles: https://support.dbagenesis.com  -  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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
24:25
January 3, 2020
Load 5 million rows into Oracle | #dailyDBA 2
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-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - 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. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
31:42
January 2, 2020
Query is running slow! #dailyDBA 1
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!
31:39
January 1, 2020