DBA Genesis Audio Experience Arun Kumar

Questions Picked for the Episode



What is the use of Locks inside database? Why can't we use the database without locks?



Our reporting team directly works on production database and my client is insisting to give a dedicated database which will act as copy of production database. What are my options?



In one of the interviews, I was asked "In what scenario an INACTIVE session will BLOCK an active session". I really don't know the answer.



Every-time my team performs export and import, they have to drop the constraints and indexes. Post import is done, we re-create the constraints and indexes. Is there any simple method for same?



How to find performance bottleneck of a query?

-

#oracle #dbagenesis #performanceTuning

-

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

Questions picked for the episode:



I am always confused between Oracle RAC, Oracle Grid, Oracle Clusterware & Oracle ASM. Could you clarify same?



What are the benefits and drawbacks of using RAID storage?



Which is the fastest way to delete millions of records from the database?



If I purchase Oracle Enterprise Edition, do I need to take separate license for Oracle Enterprise Manager 13c?



There is no Level 0 backup taken till now, and if I start incremental Level 1 backup, will it fail or proceed? If it proceeds, can i use it to restore the DB without level 0 backup?

-

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

Questions Picked for the show



I build a custom application and want to connect it to Oracle database. What are my options?



What causes slow connection between two data centres?



Which Oracle technology will be in demand - Oracle RAC or Oracle Data Guard?



I want to provide remote DBA support services. Where should I start?



What is your one technique to be safe and not to be sorry as Oracle DBA?

-

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

Questions picked for the episode:



Whats your recommendations on when to use Indexes in a query?



Under Multi-Tenant architecture, do you recommend Global temporary tablespace or dedicated local temporary tablespace for each PDB?



How to solve ORA-00018: maximum number of sessions exceeded?



What are lockdown profiles in multi-tenant architecture?



When do you recommend to go for Oracle Autonomous Database?

-

#oracle #dbagenesis #oracle12c #oracleMultiTenant

-

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

Questions picked-up for the episode:



What is LRU list inside Oracle instance?



What is the process to secure an Oracle RMAN-generated backup?



What is the difference between Oracle RAC and Active Data Guard?



Can I run Data Pump in GUI mode?



How can I update ROWID in Oracle?

-

#oracle #dbagenesis #rman

-

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

Questions picked up for this show:



How To Restore Rman Backups On A Different Node When The Directory Structures Are Different?



We have a dblink that connects to production server. What will happen to dblink if there is a failover or switchover?



What are your recommendations on migrating a database from one OS to another OS?



I would like to rebuild standby database. Can I rebuild standby anytime or it has to be created only during primary database creation?



What is the frequency at which standby is synced with primary database?

-

#oracle #dbagenesis #goldenGate #database #dataGuard

-

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