Avoid Hard Parsing in Oracle | #dailyDBA 15

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! 00:00 When ever you are into Oracle DBA interview? 0:44 How flashback works for multi-tenant architecture? Like if I have 2 pdbs named HR and Sales inside a single CDB and I am performing any change/release in either of pdb and due to some failure I need to revert changes to original state, before changes. How will it work? 04:37 How to avoid hard parsing? 14:40 After installing 11gR2 for RAC Configuration, why we have compatible.asm=11.2.0.0.0 & compatible.rdbms=10.1.0.0.0? 17:52 What is FAL_CLIENT and FAL_SERVER? What's their purpose? 20:48 Can you please help me understand the use of swap? Bonus Question 24:46 How to clear multiple rounds of DBA interview? 29:07 # dba Challenge! Website: https://www.dbagenesis.com/ Facebook:   / dbagenesis   Instagram:   / dbagenesis   Twitter:   / dbagenesis