Print Thread
Page 1 of 2 1 2
Request: explain plan tree view cells selectable
#63464 02/25/22 11:27 AM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
koja Offline OP
Member
OP Offline
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
koja #63469 02/25/22 11:59 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
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
koja #63473 02/25/22 01:04 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
Member
Joined: Dec 2005
Posts: 2,004
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
koja #63475 02/25/22 03:02 PM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
koja Offline OP
Member
OP Offline
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
koja #63480 02/26/22 09:41 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
Okay, thanks for clarifying. We're looking into the blank HTML plan.


Marco Kalter
Allround Automations
Re: Request: explain plan tree view cells selectable
koja #63653 03/21/22 09:53 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
From the bug fix list in beta 7:
Quote
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
koja #63654 03/21/22 09:57 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
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
koja #63656 03/21/22 11:43 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
Member
Joined: Dec 2005
Posts: 2,004
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
koja #63663 03/21/22 05:02 PM
Joined: Dec 2001
Posts: 236
berlin
F
Member
Offline
Member
F
Joined: Dec 2001
Posts: 236
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
koja #63665 03/22/22 09:17 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
We'll investigate.


Marco Kalter
Allround Automations
Page 1 of 2 1 2

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.046s Queries: 15 (0.022s) Memory: 2.5578 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-20 12:56:48 UTC
Valid HTML 5 and Valid CSS