Load 5 Million Rows In 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

02:03 After upgrading database do we need to keep old binaries or can we remove it?

04:10 I am trying to load 5 million rows into one table inside Oracle. Is there anyway I can enhance the speed of load?

07:20 While upgrading from 12.1 to 12.2 the log file shows “remove events” before upgrade to 12.2. I don’t know how to remove events from Oracle. Please help!

08:50 I always struggle with tnsnames.ora file as I always mess with parenthesis. Is there a tool that you recommend to design tnsnames.ora without errors?

09:35 In Oracle RAC, do you recommend one temp file for TEMP table space for all nodes or multiple temp files?

12:25 How can I know when is the time to increase memory on server so that my Oracle instance runs fast?

17:21 How can I upgrade Oracle client from 11g to 12c version on windows system?

19:02 My manager asked me to setup Physical Standby along with Data Guard broker. Do you have specific document for same?

20:06 What are the different database migration methods available? Which method do you recommend?

24:12 What is the difference between database SID, Database name and DB unique name?

Bonus Questions
27:22 Is DBA vanishing due to cloud?

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


Load 5 Million Rows In Oracle | #dailyDBA 2