...
The following database management systems are supported:
- Installing a Database#MySQL
- Installing a Database#Microsoft SQL Server
- Installing a Database#Oracle13140004
- 13140004
- 13140004
Anchor | ||||
---|---|---|---|---|
|
Note | ||
---|---|---|
| ||
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:
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:
Panel |
---|
<pre>
show parameter open_cursors
</pre> |
A listing similar to the following will display:
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:
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 | |||
---|---|---|---|
| |||
If you do not set
|
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.
...