# Explain Plan tree view - any way to show OTHER\_XML info from plan\_table? **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [April 21, 2016, 10:21am UTC](https://forums.toadworld.com/t/explain-plan-tree-view-any-way-to-show-other-xml-info-from-plan-table/37296 "2016-04-21T10:21:46Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![droeschley\_109](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\ **Post date:** [April 21, 2016, 10:21am UTC](https://forums.toadworld.com/t/explain-plan-tree-view-any-way-to-show-other-xml-info-from-plan-table/37296/1 "2016-04-21T10:21:46Z")
I have OTHER checked in the Execution Plan Preferences, but I don’t get any of the information from OTHER\_XML. I would love to see what’s displayed in Notes section of DBMS\_Xplan. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 21, 2016, 10:47am UTC](https://forums.toadworld.com/t/explain-plan-tree-view-any-way-to-show-other-xml-info-from-plan-table/37296/2 "2016-04-21T10:47:54Z")
There is actually an OTHER column in the plan table that the “Other” setting in the plan table prefs is referring to. We currently don’t have a way to show the contents of the OTHER\_XML column, but if you look in the plan table, you’ll see that it’s not data that is human-readable. It’s certainly not what you see in the Notes section of DBMS\_XPLAN. I’ve looked in the plan table for the notes - I’ve never been able to find them. I think the DBMS\_XPLAN package must generate the notes on the fly. ---
**Author:** ![droeschley\_109](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\ **Post date:** [April 21, 2016, 11:05am UTC](https://forums.toadworld.com/t/explain-plan-tree-view-any-way-to-show-other-xml-info-from-plan-table/37296/3 "2016-04-21T11:05:40Z")
OTHER\_XML does appear to contain information displayed in Note section, at least in this particular case: Note * * * - SQL plan baseline “MDRS\_UPDATE\_20160419” used for this statement Part of OTHER\_XML “MDRS\_UPDATE\_20160419” I can send the entire OTHER\_XML output, 1171 length, if you want. A bunch of info and hint nodes for my plan. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 21, 2016, 11:55am UTC](https://forums.toadworld.com/t/explain-plan-tree-view-any-way-to-show-other-xml-info-from-plan-table/37296/4 "2016-04-21T11:55:09Z")
I guess this proves that you are not human! haha. just kidding. 🙂 I found some other\_xml data with a “select \* from all\_all\_tables”. That’s my go-to explain plan test query since the plan is pretty big. Unfortunately, there’s nothing you can do to get that column to show up in your copy of Toad. I did some work on it here and could get it to show up with a few changes, but it’s pretty awful looking with all that unformatted XML appearing in the tree. I wonder what else shows up in the notes besides baseline info, if any. ---
**Author:** ![droeschley\_109](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\ **Post date:** [April 29, 2016, 7:20am UTC](https://forums.toadworld.com/t/explain-plan-tree-view-any-way-to-show-other-xml-info-from-plan-table/37296/5 "2016-04-29T07:20:16Z")
Regarding your last question, a couple more notes I’ve seen are: Note * * * - dynamic sampling used for this statement (level=7) Note * * * - automatic DOP: Computed Degree of Parallelism is 16 because of degree limit and other messages regarding DOP. The only issue I’ve found, so far, with setting Display Mode to DBMS\_XPLAN is that in RAC, you have to be connected to the same instance as the session you’re trying to monitor. Doesn’t appear to be any easy solution to that - no INST\_ID parameter for DBMS\_XPLAN.display\_cursor, and dbms\_xplan.display\_cursor@ is not supported.