Oracle

For achieving top performance, Automic recommends keeping the following notes in mind when installing and operating Oracle.

It is important to reorganize the AE database including all clients regularly as an extensive database affects performance negatively (prolonged access times etc.).

White papers for Oracle usage can be downloaded from the Customer Zone of our website.

Notes

Do not limit resource consumption. Aborting transactions due to limitations specified in the database hamper processing in the AE system. Additionally, inconsistent database contents can occur which cause subsequent errors or endless loops.

Optimize the TCP/IP connection. For Oracle, the file sqlnet.ora is available. This file and tnsnames.ora and listener.ora are by default found in the same directory. It contains the following line:

tcp.nodelay = yes

When a message is longer than a logical transport block, it must be split in several blocks. The above line causes that this can happen without waiting for a TCP/IP response. Oracle performance can be increased this way. Enter this line on the Automation EngineDiese Komponente steuert ein Automation Engine-System. Besteht aus verschiedenen Serverprozessen. and on the DB computer.

When setting up the database, the appropriate table sizes need to be assigned. The following table provides an overview of values in percent. 2 to 4 GB should be the right database size for a productive environment. In case of extensive installations, the database size can be 10 to 20 times as large. Automic strongly recommends extending the tables for a fixed size from the beginning on and not to limit the extents.

Table	Approximate size in percent
RT	40% - 60%
AH	20% - 30%
MELD	10% - 20%
AJPP	5%
RH	5%
Other tables	< 1%

Indices should regularly be reorganized.