Long Running Query in Oracle
Posted on 2011-03-09
I am trying to run a query in Oracle 10g, when I use my ID the query takes hours and eventually will error out. I have had other users try the same query and the query finished in under 1 minute. I have compared that we are all running the same client, etc ... .
Any suggestions as to what may be causing the query to run so long for my ID or something else I could check?