RE: An app runs a query near 2k times/hr, yet not showing in AWR?
- From: Yavor Ivanov <Yavor_Ivanov@xxxxxxxx>
- To: "fmhabash@xxxxxxxxx" <fmhabash@xxxxxxxxx>, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2009 08:48:57 +0200
What about dba_hist_sql* views? Do you see your SQL there, and how many
times is it executed for the period you are looking at?
Also, do you see it in v$sql?
Regards,
Yavor Ivanov
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of FMHabash
Sent: Tuesday, February 24, 2009 9:52 PM
To: Oracle-L Group
Subject: 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:
