Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query takes very long time and analyze table hangs

CooldbaJan 17 2013 — edited Jan 17 2013

Hi

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2013

Added on Jan 17 2013

#general-database-discussions

3 comments

410 views