DBA Genesis Audio Experience

#dbaChallenge: What is the difference between soft parsing and hard parsing?

-

Questions Picked-up For This Episode:

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

1. What are the contents of oracle inventory file and in which format does it exists?

2. How will you calculate the initial size of the database?  How would you recommend the storage of datafiles, control files, redo log files etc?

3. How will cloud put the DBA role into a better position?

4. How secure my data is in the cloud?

5. Why do I see multiple values under FAL_SERVER?

Bonus Question: Who should be nervous about cloud?

-

#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: What will happen if you loose one of the control files while Oracle database is up and running?

-

Questions Picked-up For This Episode:

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

1. Can you speak about Oracle Database AutoUpgrade tool?

2. How many connections can listener handle?

3. Why data blocks are always 80% used and not 100%?

4. Can I have redo log groups with different size?

5. I lost redo log file and have no multiplexed copy or archive log. How can I recover the database?

-

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

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

-

Questions Picked-up For This Episode:

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

1. I want to know about redolog status for following scenario. We have 3 redolog groups(1,2 and 3) each group having 2 members(a andb). Q:When we are executing some DML operations by that time how the LGWR will write changes to online redologs?

whether it is writing to 1a, 1b, 2a, 2b....

or

will it write 1a and 1b simultaneously ?

2. How to find most fragmented tables and indexes that are caused of high I/O and how to get rid of them?

3. What is better to use when creating a new database: Automatic Shared memory Management or Automatic Memory Management.

4. Difference between temporary table and global temporary table?

5. Can you pls give us some tips on what steps to perform when a query is slow?

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

-

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

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

-

Questions Picked-up For This Episode:

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

1. Does select statement use UNDO? If so why?

2. If there is high I/O, does that mean its a problem with the hardware?

3. Our company has a lab practice database. At the end of each day, we would like to revert back all the changes made to the database as it was at the beginning of the day. How can we achieve it?

4. What is cost inside optimizer?

5. Are Fragmentations and High Water Mark same?

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

-

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

In this silver jubilee episode of daily DBA, I pick up the most important confusion of DBAs across the globe and that is "What is cloud?"

-

Questions Picked-up For This Episode:

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

1. What is cloud computing?

2. Is cloud secure?

3. What is hybrid cloud?

4. Can you talk about cloud certifications?

5. What are the downside of cloud?

6. Public cloud vs private cloud.

7. Which cloud is best?

8. Oracle cloud vs aws cloud

9. What are the services provided by cloud?

10. Where to learn cloud?

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #cloud

-

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

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

-

Questions Picked-up For This Episode:

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

1. I want to copy table structures (owned by single schema) from one database to another database without the table rows. How can I achieve it?

2. How can I count total records from a table faster?

3. In your experience, what is a GOOD NUMBER of database connections inside the database?

4. One query takes few seconds in MS SQL Server and same query takes few minutes in Oracle. Why?

5. Is there a way I can define the execution order of Oracle triggers?

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

-

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

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

-

Questions Picked-up For This Episode:

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

1. Can data exists above High Water Mark?

2. I have two tables: TABLE_A and TABLE_B. Table_B structure is same as TABLE_A except that it has one extra column. How can I copy records from table_A into table_B even though Table_B is having one extra column?

3. Difference between db_file_sequential_read and db_file_scattered_read.

4. How can I upgrade from Oracle 9.2.0.1 32bit to 11g 32bit version?

5. Can I create DB link between databases hosted on different OS platforms?

Bonus: I created a user inside the database and gave all necessary permissions. But I am still not able to connect via SQL Developer?

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

-

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

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

-

Questions Picked-up For This Episode:

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

1. What would you recommend as a DBA either to use sql profiles by sql tuning set or fixing plan by using sql plan management?

2. Why we put database in MOUNT RESTRICT mode before dropping database?

3. Can you explain SQL tuning advisor how to run and how to analyze it?

4. Difference between integrated capture and classic capture in golden gate? In integrated capture do we need to create the logminer database in source database or Oracle uses logminer mechanism?

5. What is virtual IP (HAIP) and how it is different from normal IP?

Bonus: I created a user inside the database and gave all necessary permissions. But I am still not able to connect via SQL Developer?

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

-

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

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

-

Questions Picked-up For This Episode:

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

1. What is materilized view and how can I purge the MV logs?

2. If locks are coming and releasing itself within 2-3 seconds, in this situation what we can do in oracle so locks does not occur even for few seconds.

3. Hi Arun, what happens if password file is deleted from the standby server? Will there be an impact on standby sync with primary? How will we fix the issue?

4. Scenario: we get complaint that one sql is taking long time for execution. When investigated and found that sql is using full table scan where it is fetching only 20% records. So we ran sql tuning advisory and fix sql profiles forcing optimizer to choose index. Finally issue got resolved query performance increased.

Later, one user runs the same sql modifying the WHERE clause which fetches 80% of the records associated in the same table.

Now what will optimizer do? Will it still use the same sql profiles which is fixed to it or it will skip sql profiles and chooses different plan?

5. What is better option for sql performance: SQL Plan Management or SQL Profiles or Hint to improvise performance of a particular sql? Or, do you advice the application team to modify their SQLs and use logical operator instead of BETWEEN, AND, OR instead of IN?

Bonus: Hi Arun, I wanted to know from your personal experience, what is one of the rarest of rare crisis situation a DBA can experience in real-time like site crash or anything that hardly any DBA sees in their entire career which most of the DBA's are scared of or the situation is very challenging.

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

-

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

In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

-

Questions Picked-up For This Episode:

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

1. How to open database when archive log is missing?

2. Could you also explain about high water mark please?

3. Why we need to rebuild the indexes?

4. When you issue SELECT * FROM EMP; does it use Indexes on the table?

5. What is the difference between data file header and data block header? What it contains?

-

#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge

-

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