Re: Time increase after first time running

From: Tim Gorman <tim_at_evdbt.com>
Date: Sun, 01 Jun 2014 15:29:31 -0600
Message-ID: <538B9B3B.5030602_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 Sun Jun 01 2014 - 23:29:31 CEST

Original text of this message