Re: Time increase after first time running

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>:

> 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