Oracle Text (MOSC)

MOSC Banner

running ctx_ddl.optimize_index with full optimization taking too long...can I kill it?

edited Jan 22, 2016 12:33PM in Oracle Text (MOSC) 2 commentsAnswered

I'm trying to optimize a very large text index using the ctx_ddl.optimize_index with the FULL parameter and a maxtime of 120. This has been running fine with a maxtime of 30, but slowly progressing through the index. So we upped the maxtime to 120 and the script has been running for 6 hours now. I was monitoring the progress and it was processing tokens but hasn't progressed in the last 4 hours. I understand that it can go beyond the maxtime, but can I safely kill the optimize without corrupting the index?

We're running 11.2.0.3.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center