Re: Time increase after first time running

From: Tim Gorman <tim_at_evdbt.com>
Date: Sun, 01 Jun 2014 17:05:15 -0600
Message-ID: <538BB1AB.9090601_at_evdbt.com>

If you want to guess, then the list might watch as you do so.

If you want to figure out what is happening and why it is happening, then provide facts (or ask how) and the list might help.

On 6/1/2014 4:07 PM, Eriovaldo Andrietta wrote:
> Hi Tim,
>
> Thanks for answer.
> I agree with you.
> I did the question as is, by the strange situation, normally occurs
> time decrease and not time increase .
> I know that I must consider the charge of the environment and lot of
> things.
>
> but in my case, the same query after running the first time , it
> increases the time running again and several times.
>
> I used the hint /*+ MATERIALIZE */ and now the query is keeping to
> same time.
>
> Regards
> Eriovaldo
>
>
>
> 2014-06-01 18:29 GMT-03:00 Tim Gorman <tim_at_evdbt.com
> <mailto:tim_at_evdbt.com>>:
>
> You've not provided basic information (i.e. Oracle version,
> platform and version, etc) nor have you provided any specific
> information (i.e. SQL text of the view, SQL trace/TKPROF output,
> DBMS_XPLAN ALLSTATS LAST output, etc).
>
> Your chances of receiving a useful response are extremely low.
>
>
>
>
>
> On 5/31/2014 9:49 PM, Eriovaldo Andrietta wrote:
>> Hello,
>>
>> I have a view that run in a Oracle 11g with RAC and when I create
>> the view and run the first time, the time is : 30 seg
>>
>> The at the second, third ... the time go to 2m:30seg
>>
>> Why does it happen ?
>>
>> I expect less than 5 seconds after firts time ...
>> Strange ...
>>
>> Regards
>> Eriovaldo
>>
>
>

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

Received on Mon Jun 02 2014 - 01:05:15 CEST