Re: RE: Re: RE: toad 11 - explain plan columns size is not saved

sebastien champy <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <11979358.308831319736778328.JavaMail.SYSTEM@alvqcfw02> 
 Message from: sebastien

I did what you suggested : deleted the two files, then opened toad again, asked for an explain plan, then customized the display to get my columns back. Both files are then recreated.

However, the behavior is really strange ... it looks like the total width of all the columns I have selected is fixed.
I have 10 columns displayed, my file content is :
&lt;epuser mode=&quot;TR&quot; fontname=&quot;tahoma&quot; fontsize=&quot;8&quot; fontstyle=&quot;&quot; color=&quot;8388608&quot; maincolwidth=&quot;655&quot; maincolpos=&quot;0&quot;&gt;
&nbsp; &lt;column id=&quot;10&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;20&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;21&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;23&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;25&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;30&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;35&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;40&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;7&quot;/&gt;
&nbsp; &lt;column id=&quot;50&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;6&quot;/&gt;
&nbsp; &lt;column id=&quot;90&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;5&quot;/&gt;
&nbsp; &lt;column id=&quot;100&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;4&quot;/&gt;
&nbsp; &lt;column id=&quot;110&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;1&quot;/&gt;
&nbsp; &lt;column id=&quot;120&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;130&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;180&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;190&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;197&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;2&quot;/&gt;
&nbsp; &lt;column id=&quot;199&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;3&quot;/&gt;
&nbsp; &lt;column id=&quot;220&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;270&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;275&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;280&quot; shown=&quot;2&quot; width=&quot;412&quot; pos=&quot;8&quot;/&gt;
&nbsp; &lt;column id=&quot;290&quot; shown=&quot;2&quot; width=&quot;395&quot; pos=&quot;9&quot;/&gt;
&lt;/epuser&gt;


If I change any column width, then next time I call explain plan, the first column will be resized so that to total width remains the same as when I called explain plan the previous time. In other words, if I widen column 2, then column 1 will be shortened by the same amount I widened column 1.
Of course, if I resize column 1, it does not have any effect because it&#39;s always column 1 that is adjusted so that the total length remains constant, so it reverts back to old setting.

Is this clear or do you want me to rephrase it ?

sebastien


_______________________________________

Historical Messages 


Author: sebastien champy
Date: Thu Oct 27 10:32:28 PDT 2011
I did what you suggested : deleted the two files, then opened toad again, asked for an explain plan, then customized the display to get my columns back. Both files are then recreated.

However, the behavior is really strange ... it looks like the total width of all the columns I have selected is fixed.
I have 10 columns displayed, my file content is :
&lt;epuser mode=&quot;TR&quot; fontname=&quot;tahoma&quot; fontsize=&quot;8&quot; fontstyle=&quot;&quot; color=&quot;8388608&quot; maincolwidth=&quot;655&quot; maincolpos=&quot;0&quot;&gt;
&nbsp; &lt;column id=&quot;10&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;20&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;21&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;23&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;25&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;30&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;35&quot; shown=&quot;1&quot; width=&quot;65&quot; pos=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;40&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;7&quot;/&gt;
&nbsp; &lt;column id=&quot;50&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;6&quot;/&gt;
&nbsp; &lt;column id=&quot;90&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;5&quot;/&gt;
&nbsp; &lt;column id=&quot;100&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;4&quot;/&gt;
&nbsp; &lt;column id=&quot;110&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;1&quot;/&gt;
&nbsp; &lt;column id=&quot;120&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;130&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;180&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;190&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;197&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;2&quot;/&gt;
&nbsp; &lt;column id=&quot;199&quot; shown=&quot;2&quot; width=&quot;65&quot; pos=&quot;3&quot;/&gt;
&nbsp; &lt;column id=&quot;220&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;270&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;275&quot; shown=&quot;0&quot;/&gt;
&nbsp; &lt;column id=&quot;280&quot; shown=&quot;2&quot; width=&quot;412&quot; pos=&quot;8&quot;/&gt;
&nbsp; &lt;column id=&quot;290&quot; shown=&quot;2&quot; width=&quot;395&quot; pos=&quot;9&quot;/&gt;
&lt;/epuser&gt;


If I change any column width, then next time I call explain plan, the first column will be resized so that to total width remains the same as when I called explain plan the previous time. In other words, if I widen column 2, then column 1 will be shortened by the same amount I widened column 1.
Of course, if I resize column 1, it does not have any effect because it&#39;s always column 1 that is adjusted so that the total length remains constant, so it reverts back to old setting.

Is this clear or do you want me to rephrase it ?

sebastien

__

Author: John Dorlon
Date: Thu Oct 27 09:57:14 PDT 2011




 

With Toad not running, try deleting ExplainPlanGlobalPrefs.XML and
ExplainPlanUserPrefs.XML. They should get recreated next time you do an explain
plan. Just don&#8217;t delete ExplainPlanColumnDefs.XML.

I just tested changing of width, order, and visibility. It&#8217;s all working
fine here and stored in ExplainPlanUserPrefs.XML. The &#8220;Shown&#8221;
attribute is visibility (0 means not visible, 1 means visible in tree, 2 means
visible as a column), &#8220;Width&#8221; is size, and &#8220;pos&#8221; is
position (it&#8217;ll be if Shown = 0 or 1)


__

Author: sebastien champy
Date: Thu Oct 27 09:57:14 PDT 2011
Hi,

Thanks for the information, this is interesting ...

ExplainPlanUserPrefs.XML is R/W, and NTFS information is weird : created on October 4th (that must be when I installed toad 11), but modified on April 25th (toad v11 build date ?).
Furthermore, if this is the same file that stores column visibility, order and size, then it stores the first two attributes (visibility and order) properly, but not size.

sebastien

__

Author: John Dorlon
Date: Thu Oct 27 06:31:31 PDT 2011




 

This is working fine for me. The path to your files will differ, but these 3
files control how the Explain plan looks.

C:\Users\jdorlon\AppData\Roaming\Quest Software\Toad for Oracle\11.0\User
Files\ExplainPlancolumnDefs.xml

C:\Users\jdorlon\AppData\Roaming\Quest Software\Toad for Oracle\11.0\User
Files\ExplainPlanGlobalPrefs.XML

C:\Users\jdorlon\AppData\Roaming\Quest Software\Toad for Oracle\11.0\User
Files\ExplainPlanUserPrefs.XML

The ExplainPlanColumnDefs.XML file does not change with your settings. It is
used to control what is available for settings.

The ExplainPlanGlobalPrefs.XML file contains information about your font
selections.

The ExplainPlanUserPrefs.XML file contains information about column visibility,
widths, and order.

It sounds like ExplainPlanUserPrefs.XML isn&#8217;t being read or written for
some reason. The file hasn&#8217;t accidentally been made read only, has it?


__

Author: sebastien champy
Date: Thu Oct 27 05:55:10 PDT 2011
Hi,

I recently upgraded to TOAD for Oracle v11.0.0, and when asking for an explain plan in query editor, the columns&#39; size always revert back to some default setting which is not appropriate. In previous versions, when I resized one or more columns, the next time I asked for an explain plan, columns&#39; size were kept.

explain plan settings :
- tree mode
- columns selected : lots of columns (cardinality, cost, io cost, cpu cost and so on)

Is there a new option somewhere to control this behavior or is this a defect ?

thanks
sebastien

__
_______________________________________
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.