|
|
 Request: explain plan tree view cells selectable
|
Joined: Mar 2007
Posts: 110 Hazerswoude-Dorp, NL
Member
|
OP
Member
Joined: Mar 2007
Posts: 110 Hazerswoude-Dorp, NL |
It would save me a lot of time if the cells in the tree-view of the explain plan result pane would be individually selectable.
The html tab stays blank btw. (Bug?)
Certainty of death, small chance of succes,
What are we waiting for... (Gimly)
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Aug 1999
Posts: 22,280
Member
|
|
Member
Joined: Aug 1999
Posts: 22,280 |
What exactly do you mean by "individually selectable"?
The HTML page seems to work fine. To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:
"C:\Program Files\PLSQL Developer 15 Beta\plsqldev.exe" DebugSQL
Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 15).
Marco Kalter
Allround Automations
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Dec 2005
Posts: 2,005 Roima Denmark
Member
|
|
Member
Joined: Dec 2005
Posts: 2,005 Roima Denmark |
I can reproduce the blank HTML page in beta 5. I am using dark theme, style=Glow.
Mail sent to support.
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Mar 2007
Posts: 110 Hazerswoude-Dorp, NL
Member
|
|
OP
Member
Joined: Mar 2007
Posts: 110 Hazerswoude-Dorp, NL |
Hi Marco, if I "select" a cell in the explain plan tree view and right click I have the option to copy, but that copies the entire explain plan. I'd like to be able to copy an index name, table name or filter predicates.
If I switch the tab from tree to HTML, the html stays empty and stays empty when I re-execute the explain plan. Tabs text and XML display information in both cases.
Certainty of death, small chance of succes,
What are we waiting for... (Gimly)
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Aug 1999
Posts: 22,280
Member
|
|
Member
Joined: Aug 1999
Posts: 22,280 |
Okay, thanks for clarifying. We're looking into the blank HTML plan.
Marco Kalter
Allround Automations
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Dec 2005
Posts: 2,005 Roima Denmark
Member
|
|
Member
Joined: Dec 2005
Posts: 2,005 Roima Denmark |
From the bug fix list in beta 7: Edge html viewer did not work in Plan Window and Test Window In the explain plan window, I still get a blank (all-white) HTML tab page. Should the quoted fix for beta 7 have fixed the explain plan HTML tab? In that case, it still doesn't work... I am using beta 7, dark theme, style=Dark Outlet Media
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Aug 1999
Posts: 22,280
Member
|
|
Member
Joined: Aug 1999
Posts: 22,280 |
This works fine for me in Beta 7 in dark mode, both 32 bit and 64 bit. Can you let me know if you have the "Use internal HTML viewer" option disabled (Preferences > User Interface > Options)?
Marco Kalter
Allround Automations
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Dec 2005
Posts: 2,005 Roima Denmark
Member
|
|
Member
Joined: Dec 2005
Posts: 2,005 Roima Denmark |
The option Use internal HTML viewer is disabled. Should I use the Install MS Edge viewer button? I already have Edge and Edge Webview installed.
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Dec 2001
Posts: 239 berlin
Member
|
|
Member
Joined: Dec 2001
Posts: 239 berlin |
I can confirm the behavior. If the option "Use internal HTML viewer" is switched off, an empty HTML tab is shown (all white). Even if the MS Edge - Ruintime is installed. At least the installer tells me that WebView2 is already there for all users.
Everything works as expected using the internal viewer.
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Aug 1999
Posts: 22,280
Member
|
|
Member
Joined: Aug 1999
Posts: 22,280 |
Marco Kalter
Allround Automations
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Aug 1999
Posts: 22,280
Member
|
|
Member
Joined: Aug 1999
Posts: 22,280 |
Can you let me know if the Report Window displays result sets, or if this is also blank for you?
Marco Kalter
Allround Automations
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Dec 2001
Posts: 239 berlin
Member
|
|
Member
Joined: Dec 2001
Posts: 239 berlin |
In contrast to the HTML output for "Explain Plan", result data is shown in the report. However, these are displayed in black and white and dark mode is not selected.
The display of the results of a report window is independent of the "Use internal HTML viewer" setting. However, the type of representation changes somewhat (different font?)
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Aug 1999
Posts: 22,280
Member
|
|
Member
Joined: Aug 1999
Posts: 22,280 |
This is exactly the problem we fixed in Beta 7. Can you go to Help > About and check if the version is 15.0.0.2047?
Marco Kalter
Allround Automations
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Dec 2001
Posts: 239 berlin
Member
|
|
Member
Joined: Dec 2001
Posts: 239 berlin |
The version I'm testing with is (15.0.0.2047) Beta (64 bit) on Windows 10 Pro 21H1
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Aug 1999
Posts: 22,280
Member
|
|
Member
Joined: Aug 1999
Posts: 22,280 |
We'll have a fix available for this in Beta 8 tomorrow.
Marco Kalter
Allround Automations
|
|
|
Re: Request: explain plan tree view cells selectable
|
Joined: Dec 2005
Posts: 2,005 Roima Denmark
Member
|
|
Member
Joined: Dec 2005
Posts: 2,005 Roima Denmark |
|
|
|
|
|
|
|
