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. 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 ?
2. How to find most fragmented tables and indexes that are caused of high I/O and how to get rid of them?
3. What is better to use when creating a new database: Automatic Shared memory Management or Automatic Memory Management.
4. Difference between temporary table and global temporary table?
5. Can you pls give us some tips on what steps to perform when a query is slow?
-
#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge
-
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:
Link to all DBA courses:
Link to real-time projects:
Link to support articles:
-
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:
Instagram:
Twitter:
Website:
Contact us: support@dbagenesis.com
-
Start your DBA Journey Today !!
0 Comments