Oracle Text (MOSC)

MOSC Banner

Extreme slow "Writing substring data ($P) to database."

edited Apr 14, 2017 7:41PM in Oracle Text (MOSC) 3 commentsAnswered

Our system makes intensive use of Oracle Text. Normally everything is working as expected, but since yesterday there is one server which "hangs" on Writing substring data ($P) to database during the indexing process. I enabled logging to get some more information, but specifically at this point there is no more information logged other then this single line. All other activity on this machine is "business as usual" and there is no slowness measurable for any user.... Only the indexing of documents does not proceed. This will become a problem in the coming days....

the sqlstatement for the session is:

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