I read below link which says that " Cost-Based Optimizer (CBO) - The CBO uses database statistics to *generate several execution* plans, picking the one with the lowest cost, where cost relates to system resources required to complete the operation."

I read below link which says that " Cost-Based Optimizer (CBO) - The CBO uses database statistics to *generate several execution* plans, picking the one with the lowest cost, where cost relates to system resources required to complete the operation."

>
Is it possible to see all the execution plan for a particular query?
My intention is to know why CBO rejects other plans.
>
A 10053 trace will include a section for all of the plans that were considered and has information for those that were rejected.