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).
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-lReceived on Sun Jun 01 2014 - 23:29:31 CEST