Avoid Hard Parsing in Oracle | #dailyDBA 15

DBA Genesis January 21, 2020
Video Thumbnail
DBA Genesis Logo

DBA Genesis

View Channel

About

DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand.

Video Description

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: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis

You May Also Like

No Recommendations Found

No products were found for the selected channel.