Re: Is there a way to skip the creation of a temporal table when gathering statistics?

*OR ALL COLUMNS SIZE SKEWONLY *is prettytime intensive . How about running it once and then change it to *SIZE REPEAT*?

Thanks
On 03.10.2016 21:10, Juan Carlos Reyes Pacheco wrote:
> when gather statistics
> * DBMS_STATS.GATHER_TABLE_STATS('SOA','HICARTERA_RW',ESTIMATE_PERCENT=>2,method_opt=>'FOR
> ALL COLUMNS SIZE SKEWONLY FOR ALL COLUMNS');
> *I found an insert that is taking a lot of time.
> Is there a way to skip it, like increasing pga memory, or something
> like that.
> Thank you :)
>
>
> INSERT /*+ append */INTO SYS.ora_temp_1_ds_1342719
> SELECT /*+ no_parallel(t) no_parallel_index(t) dbms_stats
> cursor_sharing_exact use_weak_name_resl dynamic_sampling(0)
> no_monitoring no_substrb_pad */
> "CAR_QUIEN_CUST", "SYS_NC00097$" sys_ds_alias_2,
> "SYS_NC00094$" sys_ds_alias_3, "CAR_ESVIRF" (cut)
> FROM "SOA"."HICARTERA_RW" SAMPLE (2.0000000000) t
> UNION ALL
> SELECT "CAR_QUIEN_CUST", sys_ds_alias_2, sys_ds_alias_3,
> "CAR_ESVIRF" (cut)
> FROM SYS.ora_temp_1_ds_1342719
> WHERE 1 = 0
>
>

-- 





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