Hi Friends,

I got a memory intensive running Apps (Oracle Financials)
with Ora8i DB which eats up the 2Gb memory of our
RS/6000 AIX server and has a high paging activity.

Usually or most often, I do encountered CPU intensive apps
and the way to solve it is generally check the poor tuned sql
statements (those that do full table scan).

Does poor tuned sql programs also affect or improve the
memory consumption of my apps? Or should I concentrate
on tuning the init.ora parameters?

Your help we be highly appreciated.

Thanks