memory intensive programs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: memory intensive programs

  1. #1
    Join Date
    Jan 2002
    Posts
    146
    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


  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  3. #3
    Join Date
    Jan 2002
    Posts
    146
    THANKS Orca,

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

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

  5. #5
    Join Date
    Jan 2002
    Posts
    146
    Thank you very much and more power,

  6. #6
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width