RE: inconsistent query performance

Hi Jeffrey,

Good thought but there are no variables – only literals.

Thanks.

Bob Stauffer
DBA/Database Developer

From: Beckstrom Jeffrey [mailto:JBECKSTROM_at_gcrta.org] Sent: Wednesday, January 18, 2017 1:45 PM To: Stauffer, Bob <RStauffer_at_fult.com> Subject: Re: inconsistent query performance

What about different bind variables affecting the plan?
>>> "Stauffer, Bob" <RStauffer_at_fult.com<mailto:RStauffer_at_fult.com>> 1/18/17 1:28 PM >>>
Hi all,

Oracle RDBMS EE 11.2.0.4.0 - 64bit
Red Hat Enterprise Linux 5.11

Any suggestions on how I can troubleshoot a query that performs inconsistently? Sometimes it takes a minute to run and sometimes it takes over an hour. It generally uses one of two explain plans – one fast and one slow. Although it sometimes uses a different plan. I’ve checked the stats and they are up to date. I generally run it in TOAD, but the same problem occurs in SQLPlus, SQL Developer, and other interfaces. It doesn’t matter whether the system is busy or quiet. And it happens within the same session – I can run it one right after another and it will change the plan for each execution.

Any help would be appreciated. I’m a little rusty with Oracle.

Thanks much.

Bob Stauffer
DBA/Database Developer

***CONFIDENTIALITY NOTICE***This email contains confidential information which may also be legally privileged and which is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that forwarding or copying of this email, or the taking of any action in reliance on its contents, may be strictly prohibited. If you have received this email in error, please notify us immediately by reply email and delete this message from your inbox. Thank you. E-Mail Opt Out Notice: This e-mail message may include an advertisement. You have the right to request that we not send future advertisements to you at this e-mail address. If you prefer not to receive future advertisements from us at this e-mail address, please access the following url http://www.optoutffc.com/ Fulton Financial Corporation, P.O. Box 4887, Lancaster, Pa. 17604 ***CONFIDENTIALITY NOTICE***This email contains confidential information which may also be legally privileged and which is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that forwarding or copying of this email, or the taking of any action in reliance on its contents, may be strictly prohibited. If you have received this email in error, please notify us immediately by reply email and delete this message from your inbox. Thank you. E-Mail Opt Out Notice: This e-mail message may include an advertisement. You have the right to request that we not send future advertisements to you at this e-mail address. If you prefer not to receive future advertisements from us at this e-mail address, please access the following url http://www.optoutffc.com/ Fulton Financial Corporation, P.O. Box 4887, Lancaster, Pa. 17604

--
http://www.freelists.org/webpage/oracle-l