If you are trying to debug error ORA-01436: CONNECT BY loop in user data in
the CONNECT BY sql statements, the following might help you:
ALTER SESSION
SET "_dump_connect_by_loop_data"=TRUE;
– execute the CONNECT BY here
Now look in the UDUMP destination for the trace file,
it will contain the problematic IDs which are causing the
infinite loop in the [...]