Re: RE: 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 | <20195551.309311319737861859.JavaMail.SYSTEM@alvqcfw02> |
Message from: sebastien I'm not native English speaker, so I'm not sure I use the correct terms to describe what is happening (hence my worries). I've made few more tests : no matter what I select as visible columns, and which order, it will always try to resize the column containing the steps details (the one that says which operation on which object, let's call it the "main" column) so that the total length of all columns is roughly equal to the size of TOAD windows minus a small part on the right of the window : - if I resize my main TOAD window, or the editor window only, the total length is modified, and guess what, the main column is resized too, - if I move the main column right in the middle of all columns, then it resizes it (not the first column) - etc. - if I resize any column, it will resize the main column only, - if I remove or add one column, then again the main column will be resized accordingly. So whatever happens (resize of window or any column modification), it will always adjust the main column size so that the total length is equal to the window length minus a small part on the right. I'll send you the 3 files. sebastien _______________________________________ Historical Messages Author: sebastien champy Date: Thu Oct 27 10:50:31 PDT 2011 I'm not native English speaker, so I'm not sure I use the correct terms to describe what is happening (hence my worries). I've made few more tests : no matter what I select as visible columns, and which order, it will always try to resize the column containing the steps details (the one that says which operation on which object, let's call it the "main" column) so that the total length of all columns is roughly equal to the size of TOAD windows minus a small part on the right of the window : - if I resize my main TOAD window, or the editor window only, the total length is modified, and guess what, the main column is resized too, - if I move the main column right in the middle of all columns, then it resizes it (not the first column) - etc. - if I resize any column, it will resize the main column only, - if I remove or add one column, then again the main column will be resized accordingly. So whatever happens (resize of window or any column modification), it will always adjust the main column size so that the total length is equal to the window length minus a small part on the right. I'll send you the 3 files. sebastien __ Author: John Dorlon Date: Thu Oct 27 10:32:28 PDT 2011 I understand what you are saying. I just can’t make it happen here. :-) Maybe there is something about your combination of settings that is causing the problem. Will you send all 3 of those files to me? [email protected] . Thanks. __ 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 : <epuser mode="TR" fontname="tahoma" fontsize="8" fontstyle="" color="8388608" maincolwidth="655" maincolpos="0"> <column id="10" shown="1" width="65" pos="0"/> <column id="20" shown="1" width="65" pos="0"/> <column id="21" shown="1" width="65" pos="0"/> <column id="23" shown="1" width="65" pos="0"/> <column id="25" shown="1" width="65" pos="0"/> <column id="30" shown="1" width="65" pos="0"/> <column id="35" shown="1" width="65" pos="0"/> <column id="40" shown="2" width="65" pos="7"/> <column id="50" shown="2" width="65" pos="6"/> <column id="90" shown="2" width="65" pos="5"/> <column id="100" shown="2" width="65" pos="4"/> <column id="110" shown="2" width="65" pos="1"/> <column id="120" shown="0"/> <column id="130" shown="0"/> <column id="180" shown="0"/> <column id="190" shown="0"/> <column id="197" shown="2" width="65" pos="2"/> <column id="199" shown="2" width="65" pos="3"/> <column id="220" shown="0"/> <column id="270" shown="0"/> <column id="275" shown="0"/> <column id="280" shown="2" width="412" pos="8"/> <column id="290" shown="2" width="395" pos="9"/> </epuser> 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'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’t delete ExplainPlanColumnDefs.XML. I just tested changing of width, order, and visibility. It’s all working fine here and stored in ExplainPlanUserPrefs.XML. The “Shown” attribute is visibility (0 means not visible, 1 means visible in tree, 2 means visible as a column), “Width” is size, and “pos” is position (it’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’t being read or written for some reason. The file hasn’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' 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' 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 __ _______________________________________