An app runs a query near 2k times/hr, yet not showing in AWR?
From: FMHabash <fmhabash_at_gmail.com>
Date: Tue, 24 Feb 2009 14:52:26 -0500
Message-ID: <49a44ff4.1f2d400a.748d.0066_at_mx.google.com>
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.
Date: Tue, 24 Feb 2009 14:52:26 -0500
Message-ID: <49a44ff4.1f2d400a.748d.0066_at_mx.google.com>
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-lReceived on Tue Feb 24 2009 - 13:52:26 CST