is there a way to reconnect when the database connection is lost (like Toad

SQL Optimizer SQL Optimizer for Oracle
1

Hi, is there a way like in Toad to reconnect if your database connection is lost?

Also, it doesn’t make it very clear when that happens. I would tell it to execute all selected in the tuning lab and the results comparison says ‘Execution error’ but no reason why. Of course when I ran the statement in Toad it was running fine, so I was stumped for awhile trying to figure out the problem.

2

Hi Wendy,

When you find the connection is lost, you can try to reconnect it with the following steps:

  1. Go to the Connection Manager (At the top-right corner of the application, click “Connection”)
  2. Select the row which you want to reconnect.
  3. Click “Create” button.

For the Execution Error problem in Tuning Lab, there is a “Messages” docking window in Tuning Lab to log what the the Tuning Lab session did and related error details.

You can find see the window with the steps as follow:

  1. In your Tuning Lab session, go to “SQL Details” page
  2. Under the toolbar, you will find a Layout setting path like “SQL Details -> Original SQL -> SQL Text”.
  3. Click on “SQL Text” on the path.
  4. You can now see a drop down which show a list of the layout windows.
  5. Select “Messages” from the dropdown
  6. A “Messages” window will be shown on the layout.

You can find more informaton about the Lab session processes and the details of execution error.

Please let me know if you find problems on reconnecting the database or study the execution error with the above steps.

Regards,
Polly

3

I tried doing Connection manager, Create, but it did not work. I still get the ‘not connected to oracle’ error.

4

Hi Wendy,

Is there any more information in the message that says you are not able to connect to Oracle? What happens when you try to connect to Oracle from Toad or another program like SQL*Plus?

Rene

5

I was using Toad at the same time. It is connected fine. My database connection occasionally times out in Toad during the day and I use the 'session | reconnect ’ option and that works fine.

6

I was using Toad at the same time. It is connected fine. My database connection occasionally times out in Toad during the day and I use the 'session | reconnect ’ option and that works fine.

7

Hi Wendy,

There is no such “session|reconnect” option (like Toad) in SQL Optimizer. Therefore, if there is optimization or execution in process in the Tuning Lab and then the database connection is suddenly lost, you may have to create another Tuning Lab session in order to optimize and execute again.

For the reconnect option, we are putting it in enhancement list of our product and the function will be provided in the future verson.

Regards,
Cliff