Just short note for myself: OJPPD limitations Posted on December 2, 2019 by Sayan Malakshinov Posted in CBO, collect, oracle, SQL, troubleshooting As of Oracle 19c OJPPD doesn’t support connect-by and TABLE(): OJPPD: OJPPD bypassed: query block contains START WITH/CONNECT BY. OJPPD: OJPPD bypassed: View contains TABLE expression.