Query Running Slow |

In this first episode of #dailyDBA, I will be answering some of the most asked questions by our #DBA community.

00:00 Intro
02:04 In a live production database if I want to add a column in one of the most used tables, what will happen?
04:34 How to handle heavy concurrent environment in oracle? What architecture solutions can you provide to achieve exceedingly good performance?
13:49 How can I check active bg process inside an Oracle session!
14:35 What are the things you must consider before upgrading a database in real-time?
19:37 What are the different upgrade methods available?
21:36 What if I set RMAN retention policy to none?
22:52 FRA location has space available at OS level but still Oracle alert log throws error: FRA location running out of space?
25:11 Do I need to setup backups for recovery catalog too?
26:08 How can I trigger cold backups in Oracle multi-tenant environment?
Bonus Question
29:05 My query is running slow what can i do?

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis