SQL Queries are getting queued for few users in Toad

Toad for Oracle
1

Hi there,

We have noticed that for few users the SQL queries are getting queued. These are newly created Users accessing a schema as a Proxy user. Below are the steps-

Created a User (Say A) at DB and this user access a data from another Schema as a proxy user.

User A executes 3 different queries in 3 different tabs of Toad.

If Query 1 (in tab 1) is complex and takes time, then Query 2 (in tab 2) and Query 3 (in tab 3) is queued and is not executed untill Query 1 completes execution and gives the out put. This is happening only for few newly created users (proxy)

For the old Users, if Query 1 (in tab 1) is complex and takes time, then Query 2 (in tab 2) and Query 3 (in tab 3) completes execution and gives out put (while Query 1 is still executing).

Please guide, how can we ensure that for newly created Users the queries should not get queued.

Any help in this regard would be very useful.

Thanks & regards,

Manjeet

2

Query 2 (in tab 2) and Query 3 (in tab 3) is queued and is not executed untill Query 1 completes execution and gives the out put

If this are DML queries then session blocking might occurred.

If this "queued" thing is related to Toad, then you may define "run query in threads" ... search for word "thread" in Toad options and start to use it. Then you can execute several queries in the same time on several tabs.

Otherwise I must tell that I do not understand your question, so maybe some additional explanation (or picture if possible) may help in resolving your issue.

Brg

Damir