Gather Stale Stats Oracle

https://is1-ssl.mzstatic.com/image/thumb/Podcasts115/v4/87/63/5a/87635a99-f986-111c-7b63-3597dc008760/mza_2069314630290222610.jpg/600x600bb.jpg

DBA Genesis Audio Experience

Arun Kumar

49 episodes

5 days ago

DBA Genesis is the leading platform for Database Administrators which provides Courses, Online Trainings and Real-Time DBA projects. In addition to above, DBA Genesis also provides remote DBA support and remote cloud DBA support to clients across the globe. DBA Genesis is a highly sought after corporate training platform. With over 50,000+ followers and a vision to provide simplified database learning, our goal is to reach every single DBA on this planet by 2025!

Technology

RSS

All content for DBA Genesis Audio Experience is the property of Arun Kumar and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

Technology

https://d3t3ozftmdmh3i.cloudfront.net/production/podcast_uploaded_episode/2914579/2914579-1582886604481-53574e07a8783.jpg

Gather Stale Stats Oracle | #dailyDBA 32

DBA Genesis Audio Experience

18 minutes 56 seconds

5 years ago

Gather Stale Stats Oracle | #dailyDBA 32

#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