DOMAIN_INDEX Import Slow on 18.104.22.168
(Doc ID 2280556.1)
Last updated on NOVEMBER 19, 2019
Applies to:Oracle Text - Version 22.214.171.124 and later
Information in this document applies to any platform.
On : 126.96.36.199 version, Creating/Maintaining context indexes
DOMAIN_INDEX Import slowness
Domain index import is very slow during Production DB migration and business is critically impacted .
CREATE INDEX LEXP_OT_CONTENT_FILES ON LEXP_CONTENT_FILES(FILEDATA) INDEXTYPE IS CTXSYS.CONTEXT parameters ('
language column LANGUAGE_ORA_TEXT
SYNC (ON COMMIT)'
) PARALLEL 4;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document