Oracle Text (MOSC)

MOSC Banner

Trying to identify why mass deletes from Oracle Text is SLOW

edited Jun 29, 2016 8:12AM in Oracle Text (MOSC) 4 commentsAnswered

We have some ctxsys.syncrn(:idxownid, :idxoname, :idxid, :ixpid, :rtabnm, :flg) statements that run for > 28 MINUTES each when purging old data causing severe performance issues on the delete processes. The current rate cannot keep up with data purge requirements.  Data is partitioned by day, and to reduce some perceived locking, have converted the $R to small_r_row  so a $R lob may take 2-3 rows (490000 bytes max per lob row) We can tell that it does LOBWRITEs in chunks of 6400 bytes with an average write time of .990seconds

Has anyone else experience this?

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