Is it possible to set Transaction Isolation level in Toad for Oracle? (4228981)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Is it possible to set Transaction Isolation level in Toad for Oracle?
Description

Is it possible set "Transaction Isolation Level" which is equivalent to "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" within Toad for Oracle?
Resolution

There isn't a specific GUI options that points to Transaction Isolation Level in Toad. However, run the commands within the Toad's Editor.
To run the command with every session, then use a "Startup Script".
1. In Toad, go to view | Toad Options.
2. On the new window, click on StartUp on the left.
3. On the right, select a .SQL file for the field "File to execute on new connections" where the .SQL file contains the commands you wish to run; which will be applied for all new sessions\connections made.
NOTE: Users can only see uncommitted data in the same session that made the change. Oracle does not allow other sessions to see the data until it is committed.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title