Bert Gombos
Member²
Explain plan sometimes doesn't work. After F8 no result appears.
The reason for this should relate to wrong statement id. The next select has been mined from v$sqltext:
select level, plan_table.* from plan_table where statement_id =
'' connect by prior id = parent_id and statement_id = '' start w
ith id = 0 and statement_id = '' order by id
The reason for this should relate to wrong statement id. The next select has been mined from v$sqltext:
select level, plan_table.* from plan_table where statement_id =
'' connect by prior id = parent_id and statement_id = '' start w
ith id = 0 and statement_id = '' order by id