Oracle Error Message
ORA-29383: all leaves of top-plan string must be consumer groups
Reason for the Error
An attempt was made to create or modify the specified top-plan but it has some plans as leaves.
Solution
To identify which plans and/or plan directives need to be modified, look at all plans that have no plan directives. Then, alter the top-plan so that all its leaves are consumer groups.