Axis RightFax 8.5 Installationsanleitung PDF herunterladen (Seite 86)

13-10

Statement Type

Use Case

Description

Default, in

seconds

update

directSqlUpdate

DIRECT SQL UPDATE

agent action

1800

update

default

All update statements

1800

call

directSqlUpdate

DIRECT_SQL_UPDATE

agent action

1800

call

default

All other stored procedure

calls

1800

INIT.ORA Parameters

The values of INIT.ORA tuning parameters can have a significant impact on performance. The Oracle

Transportation Management Installation Guide (Database Administration section) provides the latest

set of recommended settings for Oracle Transportation Management. These settings are guidelines

that have been established based on feedback from various customer scenarios. There is not one set

of parameters that will be optimal for all installations. These parameters need to be tuned for each

Oracle Transportation Management instance by an experienced Database Administrator.

Tuning a RAC Database Installation Using Services

RAC is the multi-node clustering capability for the Oracle Database. Oracle Transportation

Management is certified to work in a RAC configuration. A RAC configuration will allow the database to

scale, particularly in a situation where the database experiences high CPU. The default configuration of

RAC is to load-balance the work across all nodes in a cluster. In some scenarios this configuration may

result in significant contention between the RAC nodes due to the global buffer cache. Evidence of this

issue can be seen in the AWR/ADDM reports with high wait times due to the “gc cr request” and/or “gc

buffer busy” events.

An Oracle Transportation Management large, multi-threaded bulkplan process is a scenario that may

experience this problem when attempting to commit a large number of shipments across multiple

nodes in a cluster. It is possible to achieve a performance improvement by dedicating a particular

Oracle Transportation Management process to a sub-set of the nodes in the cluster in order to reduce

contention. This can be accomplished by defining services on the RAC nodes and then associating the

service in the database connect string of particular nodes in the Oracle Transportation Management

Application Server. This assumes that Oracle Transportation Management has been configured to use

Oracle Transportation Management scalability and that particular processes are being handled by

particular applications servers in the Oracle Transportation Management cluster.

The following is an example of how these services could be defined and used:

Service Name

Primary Instance(s)

Available Instance(s)

otm_oltp

rotm021, r0tm022

rotm023

otm_batch

rotm023

rotm021, rotm022

1 2 ... 81 82 83 84 85 86 87 88 89 90 91 ... 105 106

Kommentare zu diesen Handbüchern

Keine Kommentare

Axis RightFax 8.5 Installationsanleitung Seite 86

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Axis RightFax 8.5