Toad World® Forums

Limit Toad to a Single Database Connection


#1

When I establish a connection to a specific database via TOAD, can I limit all of my activity within TOAD for that database to a single session/connection? I don’t want a new or seperate connection for the Schema Browser, and another one for the Editor, and another one when I am Alter Table page following a double-click on an object in the Schema Browser. For our production databases, wer require our DBAs to “injected” into their session stream the change number of the CR that authorizes them to make whatever change that they are going to make. That change number is injected into the DBA’s session stream by simply select it from dual - i.e. SELECT ‘CR12345’ FROM DUAL as the very first command that they enter when they log into a database to make a change. This is very easy to do when using a command line tool such as SQL*Plus. However, when TOAD creates separate sessions for every new tab that is opened.


#2

A few things to look at:

Options -> Oracle -> Transactions -> Execute queries in threads - Uncheck

Options -> Oracle -> Transactions -> Execute scripts in Toad session - Check

Options -> Oracle -> Transactions -> Session for Explain Plan - Main Toad Session

On Sep 10, 2015, at 4:07 PM, les.dye bounce-lesdye@toadworld.com wrote:

Limit Toad to a Single Database Connection

Thread created by les.dye
When I establish a connection to a specific database via TOAD, can I limit all of my activity within TOAD for that database to a single session/connection? I don’t want a new or seperate connection for the Schema Browser, and another one for the Editor, and another one when I am Alter Table page following a double-click on an object in the Schema Browser. For our production databases, wer require our DBAs to “injected” into their session stream the change number of the CR that authorizes them to make whatever change that they are going to make. That change number is injected into the DBA’s session stream by simply select it from dual - i.e. SELECT ‘CR12345’ FROM DUAL as the very first command that they enter when they log into a database to make a change. This is very easy to do when using a command line tool such as SQL*Plus. However, when TOAD creates separate sessions for every new tab that is opened.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


#3

Uncheck the “Execute queries in threads” option on the Oracle|Transactions options page.

Check the “Execute scripts in Toad session” checkbox on that same page.

That’s about as close as you can get I think.

Michael

On 09/10/2015 04:08 PM, les.dye wrote:

Limit Toad to a Single Database Connection

Thread created by les.dye
When I establish a connection to a specific database via TOAD, can I limit all of my activity within TOAD for that database to a single session/connection? I don’t want a new or seperate connection for the Schema Browser, and another one for the Editor, and another one when I am Alter Table page following a double-click on an object in the Schema Browser. For our production databases, wer require our DBAs to “injected” into their session stream the change number of the CR that authorizes them to make whatever change that they are going to make. That change number is injected into the DBA’s session stream by simply select it from dual - i.e. SELECT ‘CR12345’ FROM DUAL as the very first command that they enter when they log into a database to make a change. This is very easy to do when using a command line tool such as SQL*Plus. However, when TOAD creates separate sessions for every new tab that is opened.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#4

Hi Les!

Go to Options -> Oracle -> Transactions.

Set the following options

“Execute queries in threads” => UNCHECKED

“Execute scripts in Toad session” => CHECKED

“Session for Explain Plan” => Main Toad Session

I am not sure if that will prevent separate sessions 100%, but that will get most of them.

Tell everyone over there at PepsiCo I said Hi.


#5

Jinx


#6

Will do John. Thanks for the reply, and good to hear from you. I hope all is wel with you.