Vinod Siram

This is Vinod Kumar having 15+ years of experience as Oracle DBA having exposure to RAC, Dataguard, RMAN,GoldenGate, DB Upgrades ,Hadoop. Looking forward to sharpen my skill set and adapt new things. Worked for various industries like Banking, financial, Telecom, Product based companies and retail etc.

Share this post

Query Issues (Ask questions to Dev before working on it)

Posted on October 24, 2016 in Oracle DB Admin, Performance Tuning

Share via:

Post Views: 0

Ask DB details and query details before start working on it.

When did this query last took 2 hours?
What is the change in volume of data?
How many times this query runs each day?
Start and end time of this query execution for past 1 month.
Any DDL changes e.g. indexes, column etc

Could you provide the following data.

– Is there any difference in the amount of data, that below queries are pulling out ?
– How much more time the problematic SQLs are taking compared to previous days ?

Share via:

Note: Please test scripts in Non Prod before trying in Production.