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