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!

Analyze taking long time

433409Jan 5 2006 — edited Sep 7 2006

Hi All,

I have a procedure running on a table. As it was taking too much time i killed the procedure.... than i analyzed the table for 'COMPUTE STATISTICS' ... AND IT'S TAKING TOO MUCH OF TIME .... WHERE AS SAME TABLE PREV. TOOK ONLY FEW MIN.

Regards,
Ravi Kumar M

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2006

Added on Jan 5 2006

#general-database-discussions

12 comments

838 views