Is there a way to skip the creation of a temporal table when gathering statistics?
From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Mon, 3 Oct 2016 15:10:45 -0400
Message-ID: <CAGYrQytSD3_pEVWVcJC4f=GU9p-kYKXxbvQGaRYewzzLGv0bXw_at_mail.gmail.com>
when gather statistics
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)
Date: Mon, 3 Oct 2016 15:10:45 -0400
Message-ID: <CAGYrQytSD3_pEVWVcJC4f=GU9p-kYKXxbvQGaRYewzzLGv0bXw_at_mail.gmail.com>
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 */
"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-lReceived on Mon Oct 03 2016 - 21:10:45 CEST