Cutover after applying RUP 18 patch and its consolidated patch (35672406,35672409 )
select column_value from table(cast(ctxsys.drvparx.ParallelPopuIndex(cursor(select /*+ DYNAMIC_SAMPLING(0) PARALLEL(base 16) FULL(base) NOCACHE(base) */ rowid, NULL, upper(substrb(base."FILE_FORMAT",1,128)),NULL, NULL, 'N', base."BINARY_DOC" from "PER"."IRC_DOCUMENTS" base), :idxownid, :idxid, :idxown, :idxname, :ixpname,:popstate) assys.odcivarchar2list))s hanging in below SQL
We forced to cancel the cutover job