Home » Server Options » Text & interMedia » Index creation performance problem with LOB/CLOB content ( PB12 Windows x64)
Index creation performance problem with LOB/CLOB content [message #632479] Sun, 01 February 2015 10:18 Go to next message
Messages: 1
Registered: February 2015
Location: Germany
Junior Member

i have a problem with the indexing performance with a table that contains some text columns
and also a clob and a lob column.

indexing with 20.000 rows takes about 1 hour on with latest patch bundle 12 on
win x64.

on a the process is done in a few minutes.

so what can i do to find out where the problem is?

i use auto filter and basic lexer.
OS is W 2008 R2 with latest SP and patches. OS lang is english.
DB is installed with AL32UTF8 and german and english language packs.

also looked and ctx_user_index_errors and pending and there are no errors or pending rows.
after index creation all works fine. during index creation no other user is logged on to the database.

so why is so much faster than
some advices for me?

Re: Index creation performance problem with LOB/CLOB content [message #632487 is a reply to message #632479] Sun, 01 February 2015 16:14 Go to previous message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
I can't say for sure, but my best guess is that it is the auto_filter, which is now the default. Oracle Text went through a lot of changes to the third party auto_filter between versions and that can affect index performance. I don't know that there is anything that you can do to make it better. You might try posting your question on the OTN Text forum:


Previous Topic: Oracle Text Search Performance issue with frequent words
Next Topic: Materialized view having oracle text index not returning results after complete refresh
Goto Forum:

Current Time: Sun Jun 23 15:15:05 CDT 2024