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!
00:00 Intro
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?
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
2 июл 2024