Flashback Impact On Database Performance | dailyDBA 42
Episode description
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 !!