There is a query which takes more time in production, the user has reported the issue, and we have fine tuned the same and it is working fine now in testing environment, we need to explain the user the root cause and also we need to show the user the query is running fine in production. How to show the query performance upgrade to the user in production environment?

For the same issue,...

Ranvir thakor

• May 23rd, 2019

it could be the case where that query use the table which may get affected by high volume of DML operations and table statistics are not updated one so when query is getting executed optimizer referr...

Answer Question  Select Best Answer

You have a SQL that the performance is not reliable, some days it run fast, other days, it does not, how do you troubleshoot the performance of such SQL

Prabhat Sahu

• Oct 21st, 2017

Troubleshoot SQL Performance or Tuning a SQL query: The main objective of SQL Tuning is to avoid performing unnecessary work to access rows that do not affect the result. Below are few steps we can f...

Arsh Goel

• Oct 3rd, 2016

Please check for the statistics of the tables used in the query..if the tables used are hot tables where data volume varies significantly, the statistics for the tables can play a major role in the execution time of the query.

Answer Question  Select Best Answer

Sri

• Aug 16th, 2017

Locks are to maintain read consistency and will be applied on tables and the same kind on instance memory structures is called latch.

Nishanth

• Mar 15th, 2016

The difference between the two is that Locks are queueing mechanisms while Latches are not. If two processes are spinning and waiting on a latch (access to a shared memory resource) and the resour...

Answer Question  Select Best Answer

ajit

• Jun 19th, 2017

In explain plan we need to check
1)Driving table
2)Join order
3)Join method
4)Cartition product
5)Full table scan
6)Unused index
7)Access Path

Rajesh Sinha

• May 29th, 2015

While Analyze execution Plan , Look for following :
a) driving Table
b) Join Order
c) join Method
d) Unintentional cartesion Product
e) Loops - Nested, Merge sort , Hash Join
f) Full Table Scan
g) Index available but not used
h) access Paths.

Answer Question  Select Best Answer

ranvirthakor

 Profile Answers by ranvirthakor Questions by ranvirthakor

• Jan 19th, 2017

Performance tuning definition is first of all, what are the benchmark set for system which are not met and we consider this as a performance issue and we need to tune the same. Let give an example, l...

Ashwini

• May 3rd, 2016

This content is not explanatory. using the word performance tuning in different way/manner in the explanation part doesnt make any Sense. I have commented only on Neemas answer. Rest all are meant.

Answer Question  Select Best Answer

What is Latch Free Event? When will you encounter this type of event? How will you solve it?

Nishanth

• Mar 15th, 2016

The Oracle latch free wait event occurs when a session needs a latch, tries to get the latch, but fails because someone else has it. So, it sleeps with a wait on latch free, wakes up and tries again. ...

himanshi11

 Profile Answers by himanshi11 Questions by himanshi11

• Mar 15th, 2011

Latch is basically an electronic circuitory that holds the state of a system. It stores only a single bit inforamtion at a time.

Answer Question  Select Best Answer

Can we drop hash partition in oracle table? If yes then how? If no then why?

Arun

• Dec 4th, 2013

No

Answer Question  Select Best Answer

In 10g Linux platform, today i executed a query which takes 5 minutes to execute. I executed the same query the next day it took long time to execute, what will be the problem?how to identify it?tel me the solutions also.

basheer

• Sep 25th, 2013

Might be sudden volume of surge in particular table.its required gather stats for this table. Or any change in db level or under layed object level

navin amarasiri

• Jul 6th, 2012

Try some indexing...

Answer Question  Select Best Answer

What are the steps to follow to recover the tablespace point in time?

geekano

 Profile Answers by geekano Questions by geekano

• Jan 6th, 2012

Summary Advisor, a tool for choosing and understanding materialized views. The Summary Advisor helps you achieve this performance benefit by choosing the proper set of materialized views for a given w...

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Feb 23rd, 2009

It's just an overview of the query which tell us how this query is going to perform. But it's not actual. In most cases it's actual but it may be changed while at run time due to some fact...

Mad Hatter

 Profile Answers by Mad Hatter Questions by Mad Hatter

• Nov 4th, 2008

Explain plan shows steps Oracle will be following to execute your query.This steps are: A) Plan steps with no children: A step in the plan with no dependents is a leaf of the tree (steps 6,7, and 9 ...

Answer Question  Select Best Answer