优化器主动抽取 CTE 导致执行计划走偏，查询语句超时

SELECT * FROM (
    SELECT * FROM WF_H_PROCESSINST
    UNION ALL
    SELECT * FROM WFPROCESSINST
) START WITH PROCESSINSTID = xxx
CONNECT BY PRIOR PARENTPROCID = PROCESSINSTID
ORDER BY LEVEL DESC;

SELECT /*+no_rewrite*/ * FROM (
    SELECT * FROM WF_H_PROCESSINST
    UNION ALL
    SELECT * FROM WFPROCESSINST
) START WITH PROCESSINSTID = xxx
CONNECT BY PRIOR PARENTPROCID = PROCESSINSTID
ORDER BY LEVEL DESC;

obclient> alter system set "_xsolapi_generate_with_clause"=0;