Results 1 to 3 of 3

Thread: SGA Tuning

  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Unanswered: SGA Tuning

    Hi,

    We are running SAP 4.6c with ORACLE 9.2.0.5 on AIX. Database is configured with Dynamic SGA, and we have set SGA_MAX_SIZE also.
    When we look at the memory management at OS level it shows high utilization of memory.
    We don’t know whether the memory allocated to SGA is completely used or not.
    How to find out how much memory is been utilized by the SGA, whether it needs to be allocated more
    memory or can be reduced from the SGA.

    Please help me in resolving this issue

    Thanks and Regards

    Ammes.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >When we look at the memory management at OS level it shows high utilization of memory.
    Why is it a bad thing to use all the memory that is available?
    Why would you want to have unsed memory is a system?

    SELECT * FROM V$SGA;

    What evidence do you have that memory (OS or SGA) problem to begin with?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Also dont forget the pga which is outside the sga. Check the pga_aggregate_target parameter and check v$pgastat.

    Alan

Posting Permissions

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