User facing below out of memory issue, please confirm if we can update parameter.

User facing below out of memory issue, please confirm if we can update parameter.

Error in Executing the Stored Procedure : ADDVISIBILITYDATA. ErrorDescription :

ORA-00604: error occurred at recursive SQL level 1

ORA-04030: out of process memory when trying to allocate 2808 bytes (TCHK^e23b32

12,eavp:kkestRCHistgrm)

ORA-04030: out of process memory when trying to allocate 25376 bytes (kxs-heap-c

,temporary memory)

SQL> show parameter memory_target

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

memory_target big integer 0

SQL> sho parameter db_n;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_name string DMS1UAT

SQL>