Page Comparison

...

The following database management systems are supported:

• MySQL
• Microsoft SQL Server
• Oracle

Anchor
MySQL MySQL

MySQL

...

For Windows installations, you can speed up MySQL performance by adding the following parameter to the appropriate MySQL.ini file:
 

innodb_flush_log_at_trx_commit=0

For more information about this parameter, see the MySQL documentation:

...

Prior to considering the enabledTLSProtocols connection property , you should verify the database connection using the latest Universal Controller maintenance release, as it may be using a more recent MySQL Connector/J, with functionality changed or added.

https://docsstonebranchdocs.stonebranchatlassian.comnet/confluencewiki/display/SMLRI/Universal+Controller+Maintenance+Lists

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html

...

To check the current value for maximum open cursors, issue the following sql*plus utility command:

show parameter open_cursors

A listing similar to the following will display:

SQL> show parameter open_cursors;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     1000

Setting a New Value for open_cursors

You can temporarily set the open_cursors value with the following SQL:

alter system set open_cursors=1000

To make a permanent change, you must set the open_cursors value in the initialization parameters file.
 

ORA-01000: maximum open cursors exceeded

Character Sets

Universal Controller does not stipulate a requirement for the Oracle database character set; for multilingual support, you can use the default Unicode character set of AL32UTF8.

...