Gather Stale Stats Oracle | #dailyDBA 32

DBA Genesis Audio Experience

Mar 02, 2020•19 min•Ep. 32

--:--

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

#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

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