Re: An app runs a query near 2k times/hr, yet not showing in AWR?
- From: 조동욱 <ukja.dion@xxxxxxxxx>
- To: fmhabash@xxxxxxxxx
- Date: Wed, 25 Feb 2009 21:21:03 +0900
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_wkrpos.htm#sthref7957
================================
Dion Cho - Oracle Performance Storyteller
http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)
================================
On Wed, Feb 25, 2009 at 9:14 PM, FMHabash <fmhabash@xxxxxxxxx> wrote:
> I reviewed awr docs in UG/package reference and ML. Where are these
> thresholds documented?
> Thanks
>
> -----Original Message-----
> From: Desai, Bhavik (MLITS) <Bhavik_Desai@xxxxxx>
> Sent: Wednesday, February 25, 2009 2:02 AM
> To: Yavor_Ivanov@xxxxxxxx; fmhabash@xxxxxxxxx; Oracle-L Group <
> oracle-l@xxxxxxxxxxxxx>
> Subject: RE: An app runs a query near 2k times/hr, yet not showing in AWR?
>
> Hi Yavor Ivanov,
>
> AWR reports are based on some fix THRESHOLD.EG: Thresholds for ELPALED
> TIME,PARSE,READS AND BUGGER GETS.
> See AWR doc to know values of these thresholds.
>
> If your sql is not crossing this threshold, it will not be captured in
> AWR.
>
> Regards,
> Bhavik Desai
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yavor Ivanov
> Sent: Wednesday, February 25, 2009 12:19 PM
> To: fmhabash@xxxxxxxxx; Oracle-L Group
> Subject: RE: An app runs a query near 2k times/hr, yet not showing in
> AWR?
>
>
>
> 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
>
>
>
> --------------------------------------------------------------------------
> This message w/attachments (message) may be privileged, confidential or
> proprietary, and if you are not an intended recipient, please notify the
> sender, do not use or share it and delete it. Unless specifically indicated,
> this message is not an offer to sell or a solicitation of any investment
> products or other financial product or service, an official confirmation of
> any transaction, or an official statement of Merrill Lynch. Subject to
> applicable law, Merrill Lynch may monitor, review and retain
> e-communications (EC) traveling through its networks/systems. The laws of
> the country of each sender/recipient may impact the handling of EC, and EC
> may be archived, supervised and produced in countries other than the country
> in which you are located. This message cannot be guaranteed to be secure or
> error-free. References to "Merrill Lynch" are references to any company in
> the Merrill Lynch & Co., Inc. group of companies, which are wholly-owned by
> Bank of America Corporation. Secur
> ities and Insurance Products: * Are Not FDIC Insured * Are Not Bank
> Guaranteed * May Lose Value * Are Not a Bank Deposit * Are Not a Condition
> to Any Banking Service or Activity * Are Not Insured by Any Federal
> Government Agency. Attachments that are part of this E-communication may
> have additional important disclosures and disclaimers, which you should
> read. This message is subject to terms available at the following link:
> http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch
> you consent to the foregoing.
> --------------------------------------------------------------------------
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
