Optomizer spoeed very slow with 12.9.0.60

Toad for Oracle - Beta
1

I’ve started this exact SQL before, but was asked to stop due to the load on ther database. It had over 50 alturnatives timed in 3 hours; with the latest version of TOAD only 19 alturnatives timed in 3 hours.

I’m assuming a database glitch and will restart the job…

Larry
Slow tuning_12.9.0.60.docx (147 KB)

2

I tried on .61 version (last one) and works OK.

If you still have some problems that I would advise you to start trace to see where the time is lost…

3

Thank you Damir! It was a one time glitch.