This content has been marked as final. Show 2 replies
this might be happening because of indexes being created as NOPARALLEL. Try to re-define them with DOP=8 and see if this helps (run a quick test to check this before doing any expensive DDLs).
I solved this issue.
The following is from oracle manual
Gather statistics on the indexes for this table. Index statistics gathering is not parallelized. Using this option is equivalent to running the GATHER_INDEX_STATS Procedure on each of the table's indexes. Use the constant DBMS_STATS.AUTO_CASCADE to have Oracle determine whether index statistics to be collected or not. This is the default. The default value can be changed using theSET_PARAM Procedure.
I issued the following sqls and it was successful.
exec dbms_stats.set_param('DEGREE','8'); exec dbms_stats.gather_table_stats(ownname=>'SDPSTGOUT',tabname=>'OUT_SDP_CONTACT_HIS',estimate_percent=>10, degree=>8 , method_opt=>'FOR ALL COLUMNS SIZE 1',Granularity=>'ALL',cascade=>TRUE);
Have a good day.