ctx_ddl.optimize_index() takes a long time

Hello

ctx_ddl.optimize_index() takes a long time
It runs for 60-90 mins earlier it was use to complete within 10 mins
Number of rows approx 0.5 million

Kindly let me know reason what all possible reasons can be for its delay.

Regards
Ankush
Ankush_ChawlaAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
you can trace the session running the optimize,  capture wait events and see what it's hanging on
0
 
sdstuberCommented:
has the index changed or the volume of data?  Has it always been .5 million?  is it still .5 million?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.