On 11.2.0.3 sessions were waiting when try to collect statistics with dbms_stats.
Job collecting statistics was blocked by parallel sessions of dbms_stats.
Insert /*+ append */ into sys.ora_temp_1_ds_350003 SELECT /*+ parallel(t,16) parallel_index(t,16)
According to metalink doc , this wait can be seen while using parallelism for dbms_stats.Temporary
solution is setting parallelism to 1 . For permanent solution , patch 12865902 should be applied to database.
Source : Metalink ‘enq: TS – contention’ / Hang While Gathering Statistics in Parallel [ID 1463791.1]
No comments:
Post a Comment