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

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?


From: [email protected] [mailto:[email protected]] On Behalf Of sebastien.champy_609
Sent: Thursday, October 27, 2011 7:55 AM
To: [email protected]
Subject: [toad] toad 11 - explain plan columns size is not saved



Message from: sebastien.champy_609


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


_______________________________________

Historical Messages


Author: sebastien.champy_609
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

__
_______________________________________