Document Tree
Document Properties
Kbid
295G28
Last Modified
19-Jul-2024
Added to KB
09-Jul-2020
Public Access
Everyone
Status
Online
Doc Type
References
Product
  • ICM 7.10
  • ICM 11
  • ICM 12
Job - SynchronizeAllTextIndexes

Name

SynchronizeAllTextIndexes

Domain

root

Job Dependencies

OptimizeAllTextIndexes

AcquiredResources

none

Cartridge

core

Pipeline

TextIndexes-SynchronizeAll

Affected Domain Objects

Product, Auction, Category, Costcenter, Department, Domain, Order,
Journalentry, Messagebody, Organization, Pagelet, Derivedproduct

Affected Tables

dr$auction_av_str_val*
dr$category_av_str_val*
dr$costcenter_av_str_val*
dr$department_av_str_val*
dr$domain_av_str_val*
dr$isorder_av_str_val*
dr$journalentry_ck001*
dr$messagebody_av_str_val*
dr$org_av_str_val*
dr$pageentpt_av_str_val*
dr$pagelet_av_str_val*

dr$product_ctx*
dr$product_ctx_<locale>*

dr$derivedproduc_ctx_<locale>*
dr$derivedproduct_ctx*

dr$configuration_ctx_<locale>*
dr$configurationparame_ctx*

Stored Procedure

  • intershop.database.synchronizeAllTextIndexes.Procedure (database.properties)
  • or the default: core.sync_all_ctx_indexes()

Default State

Enabled

Is Site Specific

False

Edit State

n.a.

Live State

n.a.

Server GroupJOB

Description

Synchronize all text indexes. This job calls the stored procedure configured in property
'intershop.database.synchronizeAllTextIndexes.Procedure', which is responsible for
synchronizing all text indexes of the entire database schema to maintain text indexes.

Scheduling

Starting time: 00:05
Interval: 60 min

What Happens Switched Off

Oracle Text index selection-performance decrease.

Trouble Shooting

The job calls the stored procedure core.sync_all_ctx_indexes(), which can be executed manually in database using SQL*Plus:

SQL> exec core.sync_all_ctx_indexes()
 
[2012-11-21 15:25:59.958 +00:00] Text index synchronization with parameters:
[2012-11-21 15:25:59.958 +00:00] Memory: 250M
[2012-11-21 15:25:59.959 +00:00] Parallel Degree: 2
[2012-11-21 15:25:59.959 +00:00] Tablename.Indexname                                                   PendingCount SyncElaTime s.
[2012-11-21 15:25:59.969 +00:00] AUCTION_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.971 +00:00] AUCTION_AV.AUCTION_AV_STR_VAL: finished.                                    0              0
[2012-11-21 15:25:59.972 +00:00] CATEGORY_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.972 +00:00] CATALOGCATEGORY_AV.CATEGORY_AV_STR_VAL: finished.                           0              0
[2012-11-21 15:25:59.972 +00:00] CONFIGURATIONPARAME_CTX: synchronize...
[2012-11-21 15:25:59.972 +00:00] CONFIGURATIONPARAMETER.CONFIGURATIONPARAME_CTX: finished.                   0              0
[2012-11-21 15:25:59.972 +00:00] CONFIGURATION_CTX_DE_DE: synchronize...
[2012-11-21 15:25:59.973 +00:00] CONFIGURATIONPARAMETER.CONFIGURATION_CTX_DE_DE: finished.                   0              0
[2012-11-21 15:25:59.973 +00:00] CONFIGURATION_CTX_EN_US: synchronize...
[2012-11-21 15:25:59.973 +00:00] CONFIGURATIONPARAMETER.CONFIGURATION_CTX_EN_US: finished.                   0              0
[2012-11-21 15:25:59.973 +00:00] COSTCENTER_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.974 +00:00] COSTCENTER_AV.COSTCENTER_AV_STR_VAL: finished.                              0              0
[2012-11-21 15:25:59.974 +00:00] DEPARTMENT_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.974 +00:00] DEPARTMENT_AV.DEPARTMENT_AV_STR_VAL: finished.                              0              0
[2012-11-21 15:25:59.974 +00:00] DERIVEDPRODUCT_CTX: synchronize...
[2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUCT.DERIVEDPRODUCT_CTX: finished.                                0              0
[2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUC_CTX_DE_DE: synchronize...
[2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUCT.DERIVEDPRODUC_CTX_DE_DE: finished.                           0              0
[2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUC_CTX_EN_US: synchronize...
[2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUCT.DERIVEDPRODUC_CTX_EN_US: finished.                           0              0
[2012-11-21 15:25:59.976 +00:00] DOMAIN_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.976 +00:00] DOMAIN_AV.DOMAIN_AV_STR_VAL: finished.                                      0              0
[2012-11-21 15:25:59.976 +00:00] ISORDER_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.976 +00:00] ISORDER_AV.ISORDER_AV_STR_VAL: finished.                                    0              0
[2012-11-21 15:25:59.976 +00:00] JOURNALENTRY_CK001: synchronize...
[2012-11-21 15:25:59.977 +00:00] JOURNALENTRY.JOURNALENTRY_CK001: finished.                                  0              0
[2012-11-21 15:25:59.977 +00:00] MESSAGEBODY_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.977 +00:00] MESSAGEBODY_AV.MESSAGEBODY_AV_STR_VAL: finished.                            0              0
[2012-11-21 15:25:59.977 +00:00] ORG_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.978 +00:00] ORGANIZATION_AV.ORG_AV_STR_VAL: finished.                                   0            .01
[2012-11-21 15:25:59.978 +00:00] PAGEENTPT_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.978 +00:00] PAGELETENTRYPOINT_AV.PAGEENTPT_AV_STR_VAL: finished.                        0              0
[2012-11-21 15:25:59.978 +00:00] PAGELET_AV_STR_VAL: synchronize...
[2012-11-21 15:25:59.979 +00:00] PAGELET_AV.PAGELET_AV_STR_VAL: finished.                                    0              0
[2012-11-21 15:25:59.979 +00:00] PRODUCT_CTX: synchronize...
[2012-11-21 15:26:02.232 +00:00] PRODUCT.PRODUCT_CTX: finished.                                           2267           2.25
[2012-11-21 15:26:02.232 +00:00] PRODUCT_CTX_DE_DE: synchronize...
[2012-11-21 15:26:07.829 +00:00] PRODUCT.PRODUCT_CTX_DE_DE: finished.                                     2267            5.6
[2012-11-21 15:26:07.829 +00:00] PRODUCT_CTX_EN_US: synchronize...
[2012-11-21 15:26:13.044 +00:00] PRODUCT.PRODUCT_CTX_EN_US: finished.                                     2267           5.21
 
PL/SQL procedure successfully completed.
 
Elapsed: 00:00:14.34

Comments

none

Product Version

7.3

Product To Version


Status
Disclaimer
The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.
Home
Knowledge Base
Product Releases
Log on to continue
This Knowledge Base document is reserved for registered customers.
Log on with your Intershop Entra ID to continue.
Write an email to supportadmin@intershop.de if you experience login issues,
or if you want to register as customer.