Skip to main content

Become a Query Tuning Master with the Newest Release of SQL Sentry Plan Explorer - Nice Tool

Today while going through one of the sql execution plan , came across a nice tool which can make you job easy.
This will help to tune query quickly & give a lot many insights.

 SQL Tuning


Comments

Post a Comment

Popular posts from this blog

Oracle Part

Process Increase due to error sometimes : SQL> connect / as sysdba ERROR: ORA-00020: maximum number of processes (300) exceeded or java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found Steps to increase the number for processes/sessions at database level in Oracle is as follows   1.  Log on to the database as system administrator  In SQL Plus enter:  " connect / as sysdba "   2. Set the number of processes to be desired value  In SQL Plus  " alter system set processes=  scope=spfile "   3. Unset the number of sessions to remove the default session limit In SQLPlus  " alter system reset sessions scope=spfile sid='*'  "   4. Shutdown the database In SQL Plus  " shutdown immediate "   5. Startup the database  In SQL Plus  " startup "    6. Check the changes have taken effect. In SQL Plus...
Post a Comment
Read more

Explain Plan Vs Execution Plan

Explain Plan DELETE PLAN_TABLE EXPLAIN PLAN FOR SELECT COUNT(*)   FROM ARADMIN80.T3293 WHERE ((((T3293.C230000009 = 'MAINCHANGE') AND  ((T3293.C301813800 = '20001-Test') OR (T3293.C1000000337 = '20001-Test')) AND (T3293.C1000003561 >= 1) AND (T3293.C1000003561 <= 9))  OR ((T3293.C230000009 = 'MAINHELPDESK') AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >= 0) AND (T3293.C1000003561 <= 3))  OR ((T3293.C230000009 = 'MAINWORKORDER') AND (T3293.C301813800 = '20001-Test') AND ((T3293.C1000003561 = 0) OR (T3293.C1000003561 = 1)  OR (T3293.C1000003561 = 2) OR (T3293.C1000003561 = 3) OR (T3293.C1000003561 = 4))) OR ((T3293.C230000009 = 'MAINKNOWLEDGEDATABASE')  AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >= 4) AND (T3293.C1000003561 <= 4)) OR ((T3293.C230000009 = 'MAINKNOWNERROR')  AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >=...
Post a Comment
Read more

Ansible - Agentless Architecture DevOps

Ansible  Ansible is an open source IT configuration management, deployment, and orchestration tool. It is unique from other management tools in many respects, aiming to provide large productivity gains to a wide variety of automation challenges. Example From YouTube - Short Videos - Quick to learn about Ansible  :) 
Post a Comment
Read more