Re: tracing makes the sql run faster
- From: Prasada.Gunda@xxxxxxxxxxxxxxxx
- To: ryan_gaffuri@xxxxxxxxxxx
- Date: Mon, 1 Nov 2004 16:19:39 -0500
All the tables and indexes are analyzed. Only difference is, if trace is
on, it runs faster. if trace is off, it runs slower.
I set up the trace on/off thru logon/logoff trigger for that application
user till the problem is resolved. I am cleaning up the udump directory
using a script.
Thanks.
Best Regards,
Prasad
860 843 8377
ryan_gaffuri@comc
ast.net To:
Prasada.Gunda@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
cc:
11/01/2004 03:52 Subject: Re: tracing makes the
sql run faster
PM
when tables are not analyzed or your stats are old, the moon can make
queries run at different speeds. thats usually what does it. reanalyzed the
tables.
-------------- Original message --------------
>
>
>
>
> 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.
>
*************************************************************************
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: