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.
o The character set of the database must be AL32UTF8 (UTF8).
o 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%';
o 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;
o 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;