INACTIVE Session Blocking ACTIVE Session | dailyDBA 49
Автор: DBA Genesis
Загружено: 2020-06-26
Просмотров: 13635
Описание:
00:00 DBA challenge: When do you use this ADDM report, ASH report and AWR report inside Oracle Database?
1:42 What is the use of Locks inside database? Why can't we use the database without locks?
4:39 Our reporting team directly works on production database and my client is insisting to give a dedicated database which will act as copy of production database. What are my options?
7:39 In one of the interviews, I was asked "In what scenario an INACTIVE session will BLOCK an active session". I really don't know the answer.
12:05 Every-time my team performs export and import, they have to drop the constraints and indexes. Post import is done, we re-create the constraints and indexes. Is there any simple method for same?
13:27 How to find performance bottleneck of a query?
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Упрощенные Oracle Locks [Часть I] — Понимание взаимоблокировок и блокировок](https://imager.clipsaver.ru/zbPkyqBPKQ8/max.jpg)
