Tuning Pop-up error massage at start of tuning

Toad for Oracle - Beta
1

Good Morning TOAD Beta Team,

    With Beta 12.11.0.62, I now get a pop-up error message at the start of tuning; but if you just dismiss the pop-up; tuning begins.  See attached.  The happened three times this morning.

    I tune Warehouse SQL and choose give me the best.

Error pop-up.docx (19.9 KB)

2

That message comes from one of two refactoring methods applied before optimizing. The first removes subqueries and the second corrects where clause. If you uncheck the options to refactor first you should be able to move on. Can you post the SQL used and which refactoring options you have selected?

Thanks,

Michael

3

Good Morning Michael,

    Thank you!  

    The SQL is attached.

SQL_with initial tuning error.sql (1.84 KB)

4

Good Morning Michael,

    Thank you!

    I've attached the latest SQL to throw the error.

SQL_with initial tuning error.sql (1.84 KB)

5

Good Morning Michael,

Thank you!

I’ve attached the latest SQL to throw the error in TOAD and replied twice, but cannot see how to attach a file from the TOADworld site. TOAD failed to post both times.

6

You can email it to me. michaelstaszewskiquest.com

7

the file round 3.
SQL_with initial tuning error.sql (1.84 KB)

8

Thanks, can you also share the DDL to create the tables used? etl_process_log_tbl and etl_status_log_tbl. No data needed, just the table creation scripts.

Thanks,

Michael

9

Good Morning Michael,

    Thank you!

    Yes, hopefully they are attached here.  Welkl one at a time...

STAGING.ETL_PROCESS_LOG_TBL.sql (1.79 KB)

10

Good Morning Michael,

    The post failed, so I sent the two SQL scripts to you by email.