
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved.
glog.workflow.topic.group.glog.server.agent.business.shipment.SlowTopic
=slowEventGroup
When modifying workflow threads via property sets, be sure to place your properties in
the APP_WORKFLOW_THREADING set.
Automatic Timeout for Stuck Threads
For any event queue, we can set an automatic timeout that effectively kills the thread and redirects
work to a new thread of the same name. To use this feature, you need to set:
glog.eventQueueMonitor.polling=<polling interval in seconds>
glog.eventQueueMonitor.timeout.<queue>=<timeout in seconds>
The polling interval should generally be 1/2 the smallest timeout.
For example:
glog.eventQueueMonitor.polling=60
"glog.eventQueueMonitor.timeout.transport - SMTP"=120
"glog.eventQueueMonitor.timeout.transport - HTTP"=240
In this example, the system will check every minute on the health of the SMTP and HTTP threads. If
an SMTP thread has been active longer than 2 minutes, it is interrupted and another SMTP thread is
created in its place. If an HTTP thread has been active longer than 4 minutes, it is interrupted and
another HTTP thread is created in its place.
Note: The double quotes around the property key since the queue names have spaces.
Multi-threading Bulk Plan Processing
Parts of the bulk plan process can be configured to process multiple threads simultaneously. This
behavior is enabled by the following property:
glog.task.on=true
Adding more threads to these thread groups may increase the performance of a very large bulk plan.
The following are the two key properties to control this functionality.
glog.workflow.topicGroup=planningCommit,2
glog.workflow.topicGroup=planningBuild,2
As described previously these values can only be overridden by using a !remove command in the
property file before specifying the new value. Please include your changes in the "Custom Thread
Properties" of the application server glog.properties file or the APP_WORKFLOW_THREADING property
set. See section Property File Management for more information.
There are additional properties to control the behavior of the multi-threading. The default values and a
description of each of these properties are available in the glog.task.properties file.
Database
Analyzing Tables/Gathering Statistics
The Oracle Transportation Management database performs best when optimizer statistics are gathered
using scripts provided by Oracle Transportation Management. Oracle Transportation Management
scripts gathers statistics by performing full compute for all the objects including indexes, columns with
histograms, partitions etc.
Comentarios a estos manuales