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

Questions picked up for the show:

Can I use flashback to recover a data block?

How can we significantly reduce the backup size?

Can a user change their own password in Oracle?

If we rollback to a savepoint, are the UNDO blocks generated after the savepoint released right away?

13:18 Does the RESOURCE Role already have UNLIMITED TABLESPACE privilege or I have to grant it separately?

-

#oracle #dbagenesis #database

-

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 episode:

We have a requirement - my client wants us to setup materialized view over DB Links with FAST REFRESH. What are your thoughts?

If I execute select statement multiple times, does it guarantee that the order of records will be same every-time? 

Could you let us know if enabling FLASHBACK has impact on the performance of the database ?

My client wants me to upload 72 million rows from an external table into Oracle. The table to which I have to perform import has INSERT triggers. What are your recommendations on the load?

Can you give me one simple example that causes row movement inside Oracle?

-

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

0:00 #dbaChallenge: what changes you will make inside Oracle database to avoid ORA-1555 error?

-

Questions Picked-up For This Episode:

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

When is the best time to gather table / schema stats?

What is your recommendations on DB block size for OLTP and data warehouse systems?

Difference between Oracle 10g and 11g?

My database archive space gets full every week. I have to remove archives manually "RMAN delete archivelog all;" Any workaround?

What are wait events inside Oracle Database?

--

Bonus Question: 

How ORACLE DBA interviews are conducted? 

--

#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

In this episode of daily DBA, I speak about Grant User DBAChallenge!

-

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