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;