Toad World® Forums

Displaying cached execution plan in "tree display" without inactive steps for adaptive plans

May I request this option(displaying cached execution plan in "tree display" without inactive steps for adaptive plans) be added to Toad for Oracle(which means there will be a switch or option selection (a) include inactive steps (b) active steps only ?

The problem is that the tree gets its data from v$sql_plan or from TOAD_PLAN_TABLE, and I don't see any information in there to identify if a plan is adaptive, and if so, which steps.

I hope this link may help in some way.

https://martincarstenbach.wordpress.com/2015/01/13/adaptive-plans-and-vsql_plan-and-related-views/

That is helpful, thank you.

You are welcome.