Oracle database performance tuning

To ensure that the Oracle database functions correctly, we can enable XA recovery or configure TCP setting.

• Enabling XA recovery operations
  Oracle requires the granting of special permissions to enable XA recovery operations.
• Configure TCP KeepAlive settings
  The failover design of the messaging engine relies upon the database connections that are broken when a messaging engine incarnation fails. In order for failover to occur in high availability environments, ensure that the RDBMS detects the broken connection in a timely manner and releases database locks. This task is done by configuring the TCP KeepAlive settings.

Parent topic: Install the Oracle database

Related

• Tasks for creating the database

Related tasks

• Create ISIM database
• Starting the Oracle product and the listener service