Slow Running Query Tips |

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!
00:00 Intro
0:41 I want to know about redolog status for following scenario. We have 3 redolog groups(1,2 and 3) each group having 2 members(a andb). Q:When we are executing some DML operations by that time how the LGWR will write changes to online redologs?
whether it is writing to 1a, 1b, 2a, 2b....
or
will it write 1a and 1b simultaneously ?
03:11 How to find most fragmented tables and indexes that are caused of high I/O and how to get rid of them?
04:07 What is better to use when creating a new database: Automatic Shared memory Management or Automatic Memory Management.
07:07 Difference between temporary table and global temporary table?
08:17 Can you pls give us some tips on what steps to perform when a query is slow?
Bonus Question
13:41 What are the best practices for DBAs who are planning to move their DEV & test database to Cloud?
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis