DBA Genesis Audio Experience

0:01#dbaChallenge: One table had more number of indexes that columns?

-

Questions Picked-up For This Episode:

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

What basic stats are gathered when we run DBMS_STATS package?

#dba Challenge!

What sample size should I use?

What types of stats are considered by Optimizer?

I want to consolidate data from multiple production databases into one oracle staging database. How can I achieve it?

How can I restore indexes while restoring dropped table?

--

Bonus Question

How to say NO in an interview?

--

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: In Oracle RAC, will one node query execution check execution plan with another node?

-

Questions Picked-up For This Episode:

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

What recommendations do you have when it comes to indexes?

How to write better queries so that if there is any change at application end, no changes must be done at db end?

Why CBO is better than RBO?

What is the impact of Exadata, Cloud and SAAS products on DBA jobs?

How to define which column to create index on?

Bonus Question: How to identify fake dba vs experienced dba?

-

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: How to handle interview rejection?

-

Questions Picked-up For This Episode:

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

How can I setup primary database so that if I delete rows on primary, the rows must not be deleted on standby?

How can I generate a report of every SQL statement executed by every session?

Is Oracle RDBMS loosing edge over NoSQL?

How can I reduce Concurrency wait event?

Can we create PDB from an existing PDB via DBLINK?

Bonus Question: How to handle interview rejection?

-

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: Can we trigger RMAN backups via OEM?

-

Questions Picked-up For This Episode:

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

I'm unable to install Oracle Database after uninstalling it on windows system. What could be the issue?

When I mount database, why it hangs indefinitely?

How come two session are running same sql_id inside Oracle database?

What is the best way to upgrade from 9i to 12c when DB size is 52 GB?

How can I convert from Oracle multi-tenant (CDB) to NON-CDB?

Bonus Question: How to learn things faster

-

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: Read about Oracle SAVEPOINT!

-

Questions Picked-up For This Episode:

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

Can we perform any transactions in physical standby mode?

What is the difference between obsolete and expired backup?

What is SAVEPOINT in Oracle SQL?

How can I kill all sessions inside Oracle at once?

Which is the best way to upload excel sheet into Oracle?

Bonus Question: Low confidence DBAs

-

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: Why Oracle RAC has only 3 SCAN listener?

-

Questions Picked-up For This Episode:

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

I feel our production database is running slow, can I increase SGA by 5 GB?

What is the difference between Oracle Database and Oracle Exadata?

How to load data into another database from oracle database?

How can I get username of the user that inserted a record in a table?

Query running slow post upgrade to 18c?

Bonus Question: What's your recommendation for setting up Oracle practice lab at home!

-

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: Which cases sql plan hash value will change?

-

Questions Picked-up For This Episode:

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

If RMNA backups are residing on different DISK GROUPS then can we restore the rman backup? If yes then is there any specific change is needed in restore syntax?

How to fix when undo tablespace get corrupted?

Is optimizer smart enough to choose between index scan and table scan?

What is the difference between using table_name and schema.table_name in a query?

cdump location is growing faster and filling up entire /data mount point. What to do?

Bonus Question: Must have tools for Oracle DBAs.

-

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: What is the simplest way to enable all the triggers owned by a schema?

-

Questions Picked-up For This Episode:

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

1. With the cloud transition, is the DBA job getting more difficult or more easy?

2. There are two queries - Q1 and Q2. Optimizer cost for Q1 is less than Q2. But Q2 executes faster. Why?

3. I would like to know more about Autonomous Databases and how will it change the current roles we DBAs have now?

4. Difference between srvctl start scan vs srvctl start scan_listener?

5. What is the difference between ASM Striping and ASM Rebalancing?

Bonus Question: Application team is trying to populate 52,000 names in their application interface. Workaround!

-

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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

#dbaChallenge: How can you connect application to new primary, previously standby, without any downtime to application?

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

Contact us: [email protected]

-

Start your DBA Journey Today !!

Become an exclusive DBA Genesis member:

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