AW: An app runs a query near 2k times/hr, yet not showing in AWR?
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: <fmhabash@xxxxxxxxx>, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2009 20:34:01 +0100
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » AW: An app runs a query near 2k times/hr, yet not showing in AWR? - Martin Berger
