AW: An app runs a query near 2k times/hr, yet not showing in AWR?

If you are on 11.1.0.6+ and you know the SQL (sqlid) just google for "colored 
sql".

Hth
 Martin


----- Ursprüngliche Nachricht -----
Von: FMHabash <fmhabash@xxxxxxxxx>
Gesendet: Dienstag, 24. Februar 2009 20:52
An: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
Betreff: An app runs a query near 2k times/hr, yet not showing in AWR?

This is a query that app teams claims to be running at least 2k/hr, yet we are 
not seeing it to show in AWR. These are potential causes we came up with...
1- query changed sql-id as a result of a parse. Searching by its text, did not 
show query running at all.

2- query is parsed with every execution, therefore will post with exec=1 and 
never show in qwr report.

What further causes or dianostics can help in diagnosing this issue?

Thank you 

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Other related posts: