High memory consumption
Hi there,
I have been seeing high memory consumption by similar SQLs from multiple processes which is eating up much resources in the server. SQL is shown below..
begin fndcp_tmsrv.read_message(:ec, :to, :typ, :enddt, :rid, :retid, :nl, :nc, :dl, :secgrp, :usr, :rspap, :rsp, :log, :app, :prg, :argc, :orgt, :orgid, :a1, :a2, :a3, :a4, :a5, :a6, :a7, :a8,
:a9, :a10, :a11, :a12, :a13, :a14, :a15, :a16, :a17, :a18, :a19, :a20); end;
Any idea about this, and how can i eliminate this?
Thanks,
Saroj
1