Recent content by ScottSD

  1. S

    alter session in explain plan window

    I agree wholeheartedly. While I was able to get my serial explain plan by issuing the alter session command in the explain window, it was cumbersome -- only 1 command in the window at a time. The explain plan window definitely needs something like 'Autoselect Statement' to make it more...
  2. S

    Explain plan fails to launch from SQL window

    The Explain Window fails to launch (via F5) from the SQL Window when the SQL window contains a CTAS statement with subquery_factoring_clause. For example: create table [TABLE] as with as ( select ... from ... group by .... grouping sets (.....) ) select ... from group by ..... ...
  3. S

    Display execution plans stored in plan_table

    Is there any way to retrieve an execution plan stored in a table (plan_table) and display it in PL/SQL developer? I like to store plans for future reference. Would be nice if I could display them in PL/SQL developer.
  4. S

    alter session in explain plan window

    This didn't work for me. I wanted to compare a parallel execution plan to a serial execution plan. I switched to single session, restarted the application and then executed: ALTER SESSION DISABLE PARALLEL QUERY ; The explain plan window still gave me a parallel execution plan (even if I...
  5. S

    Enhancement Request: Close All Other Windows

    I'd like to a request an additional method for closing windows. Most text editors (i.e., UltraEdit) and tabbed browsers allow you to close all windows/tabs except the one with current focus. I would love to have this ability in PL/SQL developer. I frequently do a close all and then reopen a...
See more
Back
Top