Oracle Text (MOSC)

MOSC Banner

(INSERT/UPDATE/MERGE/DELETE) Slow performance on table after creating CTXSYS.CONTEXT text index on o

edited Feb 28, 2012 8:28PM in Oracle Text (MOSC) 1 comment
Hi,

We have a table having around half a million records. We created CTXSYS.CONTEXT text index on one of the columns of type varchar2(4000 Byte).

Before creating the text index it took us 1 Second to Merge 5000 Records into the table while selecting from another table.

After creating the text index on the table the same merge as above is taking 7 seconds.

I have tried following parameters for the index but to no avail:

    SYNC (MANUAL)
    nontransactional
    nopopulate 

Our environment is Oracle 11G R2 64bit database on Windows 2008 Server 64bit.

Can anyone help on how to get the performance back up.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center