Hi,

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 11.2.0.4 with latest patch bundle 12 on
win x64.

on a 11.2.0.1 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 11.2.0.1 is so much faster than 11.2.0.4?
some advices for me?

Thank You!!!

I didn't find the right solution from the Internet.
References
http://www.orafaq.com/forum/t/196265/
Corporate Whiteboard Examples

Отредактировано Williamhawk (2017-11-27 10:52:54)