Re: View strange when use create table as

Viajy.

I am retrieving the plan in both cases and I will check if they are different.

I did it and it ran immediatelly:
set autotrace traceonly explain
spool plan.txt
select * from v_view;
spool off

But it will take a long time :

spool plan_create.txt
set autotrace traceonly explain
create table eri_test
as select * from v_view;
spool off
It is running since 2 hours ago ....

also I ran it before start plans in order to generate new execution plan : alter system flush BUFFER_CACHE;
alter system flush SHARED_POOL;

I am waiting for finish it.

Thanks for your attention.
Eriovaldo

2016-10-08 19:22 GMT-03:00 Vijay Sehgal <vijaysehgal21_at_gmail.com>:

> Hi Eriovaldo,
>
> To start with if you can share execution plans of the queries, you can
> also use Tanel's snapper utility to see what is your session busy with when
> ctas is being executed, or you can do a 10046 trace.
>
> Regards,
> Vijay Sehgal
>
> On Oct 8, 2016, at 5:54 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com>
> wrote:
>
> Hello,
>
> I have a view that works fine and takes 5 minutes when I do:
>
> spool eri.txt
> select * from v_view;
> spool off
>
> But, it takes 5 hours when I do :
>
> create table eri_test
> as select * from v_view;
>
> The result is 670.000 lines.
>
> I don´t believe that the disk is too slow as to take 5 hours.
>
> Any idea or comment ?
>
> Regards
> Eriovaldo
>
>

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