Database Requirements

The supported versions are Oracle 12c, 18c and 19c - 64 bit

Warning: Oracle Real Application Clusters (RAC) is not supported, especially when configured for automatic load balancing between nodes where a write on one node will need to be replicated on the other nodes.

• The character set of the database must be AL32UTF8 (UTF8).
• In order to find out what exact Oracle edition/version is actually installed:
  ‎ sqlplus.exe SYS@<DB-NAME> as SYSDBA
  ‎ select banner from v$version where BANNER like '%Edition%';
• In order to find out how much memory is actually available to the Oracle database, it is important to first understand how Oracle's memory is configuration and used :
• The actual available System Global Area (SGA) memory can be found using:
  ‎ sqlplus.exe SYS@<DB-NAME> as SYSDBA
  ‎ show sga;
  ‎ select * from v$sga;
  ‎ select * from v$sgainfo;
• The actual available Program Global Area (PGA) memory can be found using:
  ‎ sqlplus.exe SYS@<DB-NAME> as SYSDBA
  ‎ select * from v$pgastat;
• In order to find out how much processing CPU/Cores is actually available to the Oracle database, query the table v$parameter for the value of cpu_count , or query the table v$license as follows:
  ‎ sqlplus.exe SYS@<DB-NAME> as SYSDBA
  ‎ select * from v$license;