Gather Stale Stats Oracle | #dailyDBA 32 - a podcast by Arun Kumar

from 2020-03-02T11:30

:: ::

#dbaChallenge: What are the different user roles inside Oracle Multi-tenant architecture?

Questions Picked-up For This Episode:

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

1. How oracle SQL engine re-writes the query?

2. Could you please explain what is the difference between SGA_Target, PGA_Target and Memory_Target?

3. What is meant by stale stats on a table? How to resolve it?

4. Why I can't grant DBA privilege to a user inside PDB while connected to CDB as sys user?

5. How can I export schema using data pump from last full backup taken via RMAN?

Bonus Question: Oracle query running slow. Earlier it was taking 9 min and now taking 48 min.

#dailyDBA #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 !!

Become an exclusive DBA Genesis member:

https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join

Further episodes of DBA Genesis Audio Experience

Further podcasts by Arun Kumar

Website of Arun Kumar