I disabled. automatic pga memory management by setting
workarea_size_policy=MANUAL and setting SORT_AREA_SIZE=200M.
I still get out of process memory but somehow my third party aplication
is not showing any Oracle error code. It shows
a very long sql statement which it was executing and sql statement is
chopped,

I am wondering whether it is an application issue where an unusally
long sql statement is dynamically being generated,

There must be some limit to length of sql statement. What is this
limit, I will like to know?

Thanks