Find Long running session details
Find Long running session details
Blocking sessions
<b>Blocking sessions</b>
Kill the blocking sessions after confirmation from app team
[Not supported by viewer]
YES
YES
Ask App Team

- Recent changes from app side
- Volume Increase
- Last best run date/time 
[Not supported by viewer]
NO
[Not supported by viewer]
Find History of SQL
<b>Find History of SQL</b>
If Literals in where clause check force matching signature for alternative plans
[Not supported by viewer]
May be it is FIRST run. Please engage developers for further optimization
[Not supported by viewer]
NO
[Not supported by viewer]
NO
[Not supported by viewer]
YES
YES
Check any SQL plan FLIPS
<b>Check any SQL plan FLIPS</b><br>
STALE STATS
<b>STALE STATS</b>
YES
YES
YES
YES
SQL TUNING ADVIOSR
<b>SQL TUNING ADVIOSR</b>
OR
[Not supported by viewer]
NO
[Not supported by viewer]
PIN the Optimal Plan
<b>PIN the Optimal Plan</b>
Collect STATS on on respective objects
<b>Collect STATS on on respective objects</b>
YES
YES
NO
[Not supported by viewer]
COMPARE  GOOD & BAD PT REPORTS

--  Rows processed with best run time
--  Increase in volume/Data
--  No of executions
--  PGA/TEMP allocation
--  CPU -- waits related CPU
--  I/O  -- check any issues at storage layer or Any spike in I/O
--  Verify other than CPU / IO waits are TOP waits
--  If parallel query involved in the plan, compare parallel salves used
[Not supported by viewer]
SQLT
<b>SQLT</b>
SQL HC
<b>SQL HC</b>
YES
YES
YES
YES
Ask APP team to re-run the JOB
[Not supported by viewer]
YES
YES
FRAGMENTATION
[Not supported by viewer]
DE-FRAGMENTATION
<b><font color="#000000">DE-FRAGMENTATION</font></b>
YES
YES
YES
YES
NO
[Not supported by viewer]
CHECK THE PERFORMANCE OF CHILD QUERY WHICH HAS SPAWNED FROM PARENT QUERY
<b><font color="#000000">CHECK THE PERFORMANCE OF CHILD QUERY WHICH HAS SPAWNED FROM PARENT QUERY</font></b>
SLOWNESS AFTER RECENT PATCHING/DATABASE/SERVER RESTART
COMPARE IF ANY DB PARAMETERS CHANGE
[Not supported by viewer]
LOGON
TO
DATABASE
[Not supported by viewer]
IF NO SOLUTION, CONTACT ORACLE SUPPORT AND FIX THE ISSUE
[Not supported by viewer]