Avoid Hard Parsing in Oracle | #dailyDBA 15

DBA Genesis Audio Experience

Jan 21, 2020•30 min•Ep. 15

--:--

Listen in podcast apps:

Apple Podcasts

Spotify

Download

Listen to this episode in Metacast mobile app

Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

In this episode of daily DBA, I pick up 6 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

Questions Picked-up For This Episode:

============================

1. 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?

2. How to avoid hard parsing?

3. After installing 11gR2 for RAC Configuration, why we have compatible.asm=11.2.0.0.0 & compatible.rdbms=10.1.0.0.0?

4. What is FAL_CLIENT and FAL_SERVER? What's their purpose?

5. Can you please help me understand the use of swap?

#dailyDBA #oracleDatabase #cloudDBA #dbaGenesis

Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)

Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration

Link to all DBA courses: https://dbagenesis.com/courses

Link to real-time projects: https://dbagenesis.com/p/projects

Link to support articles: https://support.dbagenesis.com

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 with a challenging project to push you out of your comfort zone!!

DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.

Facebook: https://www.facebook.com/dbagenesis/

Instagram: https://www.instagram.com/dbagenesis/

Twitter: https://twitter.com/DbaGenesis

Website: https://dbagenesis.com/

Start your DBA Journey Today !!

For the best experience, listen in Metacast app for iOS or Android