Query takes very long time and analyze table hangs
CooldbaJan 17 2013 — edited Jan 17 2013Hi
One of the oracle query taking very long time (ie more than a day) and affecting business requirment of getting the report in time.
I tried to analyze the table with compute statistics option, however it hangs/runs forever on one of the huge table?
Please let me know how to troubleshoot this issue