- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
ctxsys.syncrn runs and slows down data load on table having Text index
We are on this Oracle version:
Oracle Database 18c Enterprise Edition Release 126.96.36.199.0 - Production
Our use case:
Every morning we are loading a lot of data into a table. The data is loaded from a powershell script that has 6 database connection that run in parallel,
We do not need the Oracle Text index to be synchronized before all data has been loaded into the table.
However, during data load, this statement can be seen to run after a transaction has added rows to the table:
The statement ctxsys.syncrn... runs for several minutes and increases the total load time from 1 to 4 hours.
How can we avoid ctxsys.syncrn from being run?
We only need CTX_DDL.SYNC_INDEX(......) to run after all data has been loaded into the table.
Our text index was created like this:
CREATE INDEX MY_ALL_TEXT_IDX
INDEXTYPE IS CTXSYS.CONTEXT