Flashback Impact On Database Performance | dailyDBA 42

Questions picked up for this episode:

We have a requirement - my client wants us to setup materialized view over DB Links with FAST REFRESH. What are your thoughts?

If I execute select statement multiple times, does it guarantee that the order of records will be same every-time? 

Could you let us know if enabling FLASHBACK has impact on the performance of the database ?

My client wants me to upload 72 million rows from an external table into Oracle. The table to which I have to perform import has INSERT triggers. What are your recommendations on the load?

Can you give me one simple example that causes row movement inside Oracle?

-

#oracle #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 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/

Contact us: https://dbagenesis.com/p/contact

-

Start your DBA Journey Today !!