Toad World® Forums

SQL optimzer in the same session


#1

I am using Toad for Oracle -10. When ever i laaunch a quest SQL optimizer it is getting connected to DB as a seperate session. Instead of the same session. But previously i used to use 9.7.2 in that when just click optimiser button from SQL editor window sql optimizer will launch but it runs on the same session, i dont see a seperate session on the sessions browser with a separate SID. How do i get this in 10 ??

Please help

Thanks
Raj


#2

Hi Raj,

SQL Optimizer always run on its own connection session. This is the way it is in Toad 9.7.2 and Toad 10.

Can you please explain more what you want to achieve? What is the reason you want Optimizer to run on the same session? What is it not working for you?

Thanks,
Alex