The following is seen In the event_log:
Poster: 15055 - More hints may be in file /opt/app/shareplex/var/data/hints.orcl. Only 100 read into memory. (posting from orcl, queue test) [module opo]
More than 100 entries are in the hint file.
The SP_OPO_HINTS_LIMIT parameter can be adjusted accordingly. This parameter controls the maximum number of hints (table/index combinations) that can be listed in the hints file. The default value of SP_OPO_HINTS_LIMIT is 100. The value can be increased if necessary. Use hints only if you see that Post is doing full table scans on tables where there are defined indices. The post process needs to be restarted for the parameter change to take affect.
Using a large number of hints can reduce the performance of the Post process. See Chapter 5 of the SharePlex Administrator's Guide for more information about the hints feature.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center