tracing makes the sql run faster

From: <Prasada.Gunda_at_hartfordlife.com>
Date: Mon, 1 Nov 2004 14:00:44 -0500
Message-ID: <OFB8D40FCE.378F0B9C-ON85256F3F.006698D1-05256F3F.00682A83@hartfordlife.com>

Hello All,

We have an application which uses Oracle Forms 6i. One particular query takes very long time when it runs in the forms application. When I trace the user session to see what was going on, surprisingly query runs much faster and tkprof output looks fine. This query runs faster when I run it sqlplus even with out the trace on.

How else I can trace to see what is going on? Did any one experience this before? I am working with Oracle but wanted to check here as well. Environment : 9.2.0.5 and Sun Solaris.

Any thoughts or inputs are much appreciated.

Thanks.

Best Regards,
Prasad
860 843 8377

---

PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.

---

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

Received on Mon Nov 01 2004 - 12:56:43 CST