memory intensive programs

[rommel]

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

[Orca777]

hi;
A Full-Tablsscan does not affect the PGA/SGA memory.
But
*a sort can do depending on SORT_AREA_SIZE
*intensive us of packages with a lot of packag-data
*many open cursors
*batchprograms often use mor memory

Orca

[rommel]

THANKS Orca,

Do you think I should familiarize first with the
Oracle Financial Apps before I could tune this
memory problem?

[Orca777]

Hi;
You should get familare with the Apps. Best results i always got in a team knowing Oracle AND the Application.

On the other side look into V$session/V$sesstat to identify the sessions using the largest amount of mem, and then ask on the AppSite what the App is doing.

Have a look on the SORT_AREA_* -Params too they can waiste large memory if they are set to high.

You can control the number of Disk/Memory-Sorts in the v$sysstat-View

Orca

[rommel]

Thank you very much and more power,

[Orca777]

Hi;
Check the size of the db_cache;
Probably if the HitRate is higher than 97% you could
decrease the size step by step;

Orca