SQL Profile vs SQL Plan Management | #dailyDBA 21

SQL Profile vs SQL Plan Management | #dailyDBA 21

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!

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:

03:06 What is materilized view and how can I purge the MV logs?

05:43 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.

07:34 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?

10:36 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?

15:27 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?

25:13 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 ;)

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.

Start your DBA Journey Today !!

sql sql profile sql plan management

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger

Debug SQL stored procedures and develop your SQL database project with dbForge SQL Complete, a new add-in for Visual Studio and SSMS. When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool, it is essential to test the “Live” behavior of your code by making sure that each small piece of code works fine and being able to allocate any error message that may cause a failure within that code.

Create a Database in SQL Server Using SQL Server Management Studio (SSMS)

Learn how to Create a Database in SQL Server Using SQL Server Management Studio (SSMS). This article briefly explains creating a new database with the New Database wizard of SQL Server Management Studio (SSMS).

The Easy Guide on How to Use Subqueries in SQL Server

This article provides an outlook on various types of subqueries in SQL such as select or other T-SQL statements and caveats when using them.

Managing your Replication in SQL Server

Managing your Replication in SQL Server. Replication is one of the oldest technologies on MS SQL Server, loved by every database administrator. Article shows tips and T-SQL scripts to use when you need to check many SQL Agent jobs are created after the replication configuration.