INACTIVE Session Blocking ACTIVE Session | dailyDBA 49

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