Oracle 19 - CPU and Memory threshold parameters

[#1]

Hi Experts,

Are there any Oracle DB parameters for controlling the CPU and Memory consumption in SAP environment.

Please let me know.

Thanks in advance

[janos_mucsi-besze · Accepted solution]

Actually, we have SAP notes about that.

789011 - FAQ: Oracle memory areas

2470718 - Oracle Database Parameter 12.2 / 18c / 19c

The memory consumption is controlled by sga_... and pga_... parameters ins general. You may need to configure these accordingly.

[mamartins]

From official ORACLE documentation:

Automatic Memory Management

Beginning with Release 11g, Oracle Database can manage the SGA memory and instance PGA memory completely automatically. You designate only the total memory size to be used by the instance, and Oracle Database dynamically exchanges memory between the SGA and the instance PGA as needed to meet processing demands. This capability is referred to as automatic memory management. With this memory management method, the database also dynamically tunes the sizes of the individual SGA components and the sizes of the individual PGAs.

https://blogs.oracle.com/database/post/dynamic-cpu-scaling-in-oracle-database-19c