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,