Performance - EBS (MOSC)

MOSC Banner

High memory consumption

edited Jan 25, 2012 7:38PM in Performance - EBS (MOSC) 13 comments

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center