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

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)


From: [email protected] [mailto:[email protected]] On Behalf Of sebastien champy
Sent: Thursday, October 27, 2011 11:57 AM
To: [email protected]
Subject: [toad] Re: RE: toad 11 - explain plan columns size is not saved



Message from: sebastien


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


_______________________________________

Historical Messages


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

__
_______________________________________