Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following database management systems are supported:

Anchor
MySQL
MySQL
MySQL

Note
titleNote

MySQL versions 5.7.x and 8.0.x are supported.

...

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

html-bobswift
Panel
<pre>
innodb_flush_log_at_trx_commit=0
</pre>

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

...

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

html-bobswift
Panel
<pre>
show parameter open_cursors
</pre>

A listing similar to the following will display:

html-bobswift
Panel
<pre>
SQL> show parameter open_cursors;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     1000
</pre>


Setting a New Value for open_cursors

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

html-bobswift
Panel
<pre>
alter system set open_cursors=1000
</pre>

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

Note
titleNote

If you do not set open_cursors to 1000, you could receive the following error message during large imports:
 

html-bobswift
Panel
<pre>
ORA-01000: maximum open cursors exceeded
</pre>



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.

...