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

__
_______________________________________