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

From: FMHabash <>
Date: Tue, 24 Feb 2009 14:52:26 -0500
Message-ID: <>

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

Received on Tue Feb 24 2009 - 13:52:26 CST

Original text of this message