Slow Running Query Tips | #dailyDBA 27

Slow Running Query Tips | #dailyDBA 27

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:

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?

#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 ;)

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

query

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

How model queries work in Django

In this post, you will learn model queries work in Django with interactive Django shell and the shell is very powerful tool to make the django ORM queries.

React Query Tutorial | React Query For Beginners

Hey everyone! Today's video is a short tutorial for React Query, I've been using it for a few months now and it's been great! Would definitely recommend checking it out.

React Query Mutations Tutorial

Hey everyone! In this week's video, we are taking another look at React Query, specifically how to handle mutations. Hope you enjoy it!

Projection Queries: A Way to Optimize Data Traffic

Projection Queries: A Way to Optimize Data Traffic. What's so special about it? Why is it used by so many professionals? Read this article to the end and you will understand.

SQL Query Optimization: 5 Core Facts to Boost Queries

This article is a primer for developers new to SQL query optimization. It tackles 5 main points to optimize queries with examples. SQL Query Optimization: 5 Core Facts to Boost Queries.