We execute a query through the web app that takes 55 seconds to complete. While this query is executing, we execute another query against the same table in a different browser. It normally takes a few seconds, but it will not complete until the first one does.
If we do the same thing in two instances of TOAD (sql query tool), the second query returns immediately. Can someone shed some light on what is going on, where to look, etc.? Thanks, Brian Barnett