Rebuild Indexes Faster in Oracle | #dailyDBA 4

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!

#oracle #dba #cloud #dailyDBA

02:35 What is the difference between local partition Index and Global partition Index?

05:52 I have two databases on one server. There is only one listener that accepts connections for both databases. How can I configure separate listeners for the databases?

08:42 What are the performance options for a fast index rebuild?

12:19 Before RMAN backup starts, what preparations are done inside the RMAN…?

16:52 A new schema was created with USERS as the default tablespace instead of TS_E6B. There are objects already created in the USERS tablespace with around 140 GB. How can I move the objects related with that schema to the correct schema tablespace TS_E6B?

18:36 When I query v$sql or v$sqlarea, I do not see the details about one SQL ID. How can I see history SQL queries and find a specific SQL with SQL ID?

Bonus Question
20:59 I am confused between Oracle RAC and Oracle Golden Gate. Which one do you recommend and why?

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

#oracle #rebuild

Rebuild Indexes Faster in Oracle | #dailyDBA 4