The ora_lreg_db process in our test environment(19.15) is currently using 9G of memory and growing. The memory issue is also in our PROD 19.14 environment for the LREG_APX and LREG_ASM processes.
In our test environment we patched to 19.15 and Oracle support recommended patches 31094625 and 31315923. The issue is still occuring. I'm just checking if anyone else has similar issue or a resolution. I still have an SR open with Oracle Support.
DB is 19.15, non-rac, Standard Edition,on a Oracle Database Appliance X8-2-HA (19.15 patchset DEV/ 19.14 PROD)
FYI: . We also have tcps configured.
Memory usage
Today:
oracle@oraclep02 ~]$ ps aux | sort +5 -6 -n -r | head -5
oracle 47725 0.3 2.4 26944420 9732376 ? Ss Jul13 31:42 ora_lreg_XX
Sunday:
oracle@oraclep02 OPatch]$ ps aux | sort +5 -6 -n -r | head -5
oracle 47725 0.3 1.8 24411044 7199016 ? Ss Jul13 23:26 ora_lreg_XX
Thanks