AIX - Oracle Memory Issues - Aix

This is a discussion on AIX - Oracle Memory Issues - Aix ; Hello, I'm posting this in the AIX area for those who may have an idea. I'm a AIX admin and the Oracle DBA and I have been working on an issue where Oracle seems to want all the RAM it ...

+ Reply to Thread
Results 1 to 9 of 9

Thread: AIX - Oracle Memory Issues

  1. AIX - Oracle Memory Issues

    Hello,

    I'm posting this in the AIX area for those who may have an idea.

    I'm a AIX admin and the Oracle DBA and I have been working on an issue
    where Oracle seems to want all the RAM it can have.

    Is it the case that Oracle Processes will take up as much RAM as
    possible? It seems everytime that Oracle Processes take up all the
    available RAM in our Production System. So everytime we add more RAM,
    it takes more up. Is this normal?

    We are running AIX 5.3 ML04 w/ Oracle 10g Server. We have mounted the
    /oradata directory w/ the CIO option which bypasses the file buffer
    area in memory to help out a bit.

    I thought the SGA and PGA areas were supposed to limit Oracle's usage
    of RAM or at least cap it to a certain point.

    Whenever I see what's occupying RAM using 'svmon -P', it's all Oracle
    Processes.

    What are other ORACLE/Unix shops doing to control RAM usage? How much
    physical RAM do you have in your servers? and how much does Oracle take
    up?

    Thanks!


  2. Re: AIX - Oracle Memory Issues

    "dawaves" wrote in message
    news:1168538965.878371.103840@i56g2000hsf.googlegr oups.com...

    > I'm a AIX admin and the Oracle DBA and I have been working on an issue
    > where Oracle seems to want all the RAM it can have.
    >
    > Is it the case that Oracle Processes will take up as much RAM as
    > possible? It seems everytime that Oracle Processes take up all the
    > available RAM in our Production System. So everytime we add more RAM,
    > it takes more up. Is this normal?


    There is something about Oracle 10 and AIX - oracle does it's own memory
    management, so you need to do some funny things. I believe Oracle's site has
    the required info.

    > What are other ORACLE/Unix shops doing to control RAM usage? How much
    > physical RAM do you have in your servers? and how much does Oracle take
    > up?


    Our AIX/Oracle server does pretty much nothing else, so yes, it uses all the
    RAM, as indeed we want it to.

    cheers,
    clive



  3. Re: AIX - Oracle Memory Issues

    We are running pSeries 6H1s on AIX 5.3 and Oracle 10G. Oracle uses as
    much ram as it can on these boxes. We also have some HP Integrity
    systems in a RAC configuration, each of the four nodes has 24GB of RAM
    and Oracle uses around 22GB right after boot, so I'd say it's normal
    behavior.

    On Jan 11, 12:23 pm, "Clive George" wrote:
    > "dawaves" wrote in messagenews:1168538965.878371.103840@i56g2000hsf.g ooglegroups.com...
    >
    > > I'm a AIX admin and the Oracle DBA and I have been working on an issue
    > > where Oracle seems to want all the RAM it can have.

    >
    > > Is it the case that Oracle Processes will take up as much RAM as
    > > possible? It seems everytime that Oracle Processes take up all the
    > > available RAM in our Production System. So everytime we add more RAM,
    > > it takes more up. Is this normal?There is something about Oracle 10 and AIX - oracle does it's own memory

    > management, so you need to do some funny things. I believe Oracle's site has
    > the required info.
    >
    > > What are other ORACLE/Unix shops doing to control RAM usage? How much
    > > physical RAM do you have in your servers? and how much does Oracle take
    > > up?Our AIX/Oracle server does pretty much nothing else, so yes, it uses all the

    > RAM, as indeed we want it to.
    >
    > cheers,
    > clive



  4. Re: AIX - Oracle Memory Issues

    Thanks for those responses Clive and John.

    Do you guys have any paging going on? Like when you do a 'vmstat 1'
    command, are there any pi's and po's?

    I'm worried that if I let Oracle grab as much memory as possible, that
    at one point in the future, Oracle will grab all the RAM and
    subsequently, any new processes spawned will have to rely on the OS to
    Page from disk to free up RAM.

    Am I just being paranoid?

    Are there any others out there that have systems in which Oracle uses
    up as much RAM as possible?

    Thanks!


    john.hoo...@gmail.com wrote:
    > We are running pSeries 6H1s on AIX 5.3 and Oracle 10G. Oracle uses as
    > much ram as it can on these boxes. We also have some HP Integrity
    > systems in a RAC configuration, each of the four nodes has 24GB of RAM
    > and Oracle uses around 22GB right after boot, so I'd say it's normal
    > behavior.
    >
    > On Jan 11, 12:23 pm, "Clive George" wrote:
    > > "dawaves" wrote in messagenews:1168538965.878371.103840@i56g2000hsf.g ooglegroups.com...
    > >
    > > > I'm a AIX admin and the Oracle DBA and I have been working on an issue
    > > > where Oracle seems to want all the RAM it can have.

    > >
    > > > Is it the case that Oracle Processes will take up as much RAM as
    > > > possible? It seems everytime that Oracle Processes take up all the
    > > > available RAM in our Production System. So everytime we add more RAM,
    > > > it takes more up. Is this normal?There is something about Oracle 10 and AIX - oracle does it's own memory

    > > management, so you need to do some funny things. I believe Oracle's site has
    > > the required info.
    > >
    > > > What are other ORACLE/Unix shops doing to control RAM usage? How much
    > > > physical RAM do you have in your servers? and how much does Oracle take
    > > > up?Our AIX/Oracle server does pretty much nothing else, so yes, it uses all the

    > > RAM, as indeed we want it to.
    > >
    > > cheers,
    > > clive



  5. Re: AIX - Oracle Memory Issues

    "dawaves" wrote in message
    news:1168558933.213671.182970@i39g2000hsf.googlegr oups.com...
    > Thanks for those responses Clive and John.
    >
    > Do you guys have any paging going on? Like when you do a 'vmstat 1'
    > command, are there any pi's and po's?
    >
    > I'm worried that if I let Oracle grab as much memory as possible, that
    > at one point in the future, Oracle will grab all the RAM and
    > subsequently, any new processes spawned will have to rely on the OS to
    > Page from disk to free up RAM.
    >
    > Am I just being paranoid?
    >
    > Are there any others out there that have systems in which Oracle uses
    > up as much RAM as possible?


    Like I said, our Oracle server is dedicated to that, so we don't really need
    to worry.

    (sorry, that probably wasn't terribly helpful :-) )

    cheers,
    clive


  6. Re: AIX - Oracle Memory Issues

    Ok I think I know why Oracle wants more and more RAM. Upon Oracle's
    recommendation, we set certain parameters within the
    /etc/security/limits file. One of those parameters is for memory w/ the
    "unlimited" parameter.

    Does anyone else have this set? (ulimit -a)

    Also if Oracle does use more and more RAM, won't it eventually consume
    all available RAM, thus causing the system to page when it reaches that
    threshold?

    I'm I worrying too much?

    Thanks!

    Clive George wrote:
    > "dawaves" wrote in message
    > news:1168558933.213671.182970@i39g2000hsf.googlegr oups.com...
    > > Thanks for those responses Clive and John.
    > >
    > > Do you guys have any paging going on? Like when you do a 'vmstat 1'
    > > command, are there any pi's and po's?
    > >
    > > I'm worried that if I let Oracle grab as much memory as possible, that
    > > at one point in the future, Oracle will grab all the RAM and
    > > subsequently, any new processes spawned will have to rely on the OS to
    > > Page from disk to free up RAM.
    > >
    > > Am I just being paranoid?
    > >
    > > Are there any others out there that have systems in which Oracle uses
    > > up as much RAM as possible?

    >
    > Like I said, our Oracle server is dedicated to that, so we don't really need
    > to worry.
    >
    > (sorry, that probably wasn't terribly helpful :-) )
    >
    > cheers,
    > clive



  7. Re: AIX - Oracle Memory Issues

    pi's stay at 0, every now and again going up to 1,2,3, then back to
    zero. po's stay at 0. Oracle 10G is pretty good at managing memory, and
    if another process is needing it, it seems pretty good at giving a bit
    up.

    Like Clive, our Oracle boxes are pretty much dedicated to only Oracle.
    We have about 60 of them total running right now, mostly on F80s and
    6F1s on AIX 5.2, along with a couple 6H1s that were just updated to AIX
    5.3. Everything is being consolidated into the Integrity/Linux Oracle
    cluster slowly but surely. I for one am wishing we had stayed with
    pSeries/AIX rather than Integrity/Linux. AIX does a better job managing
    memory than Linux does, but all in all, it works on both sides.

    On Jan 11, 5:42 pm, "dawaves" wrote:
    > Thanks for those responses Clive and John.
    >
    > Do you guys have any paging going on? Like when you do a 'vmstat 1'
    > command, are there any pi's and po's?
    >
    > I'm worried that if I let Oracle grab as much memory as possible, that
    > at one point in the future, Oracle will grab all the RAM and
    > subsequently, any new processes spawned will have to rely on the OS to
    > Page from disk to free up RAM.
    >
    > Am I just being paranoid?
    >
    > Are there any others out there that have systems in which Oracle uses
    > up as much RAM as possible?
    >
    > Thanks!
    >
    > john.hoo...@gmail.com wrote:
    > > We are running pSeries 6H1s on AIX 5.3 and Oracle 10G. Oracle uses as
    > > much ram as it can on these boxes. We also have some HP Integrity
    > > systems in a RAC configuration, each of the four nodes has 24GB of RAM
    > > and Oracle uses around 22GB right after boot, so I'd say it's normal
    > > behavior.

    >
    > > On Jan 11, 12:23 pm, "Clive George" wrote:
    > > > "dawaves" wrote in messagenews:1168538965.878371.103840@i56g2000hsf.g ooglegroups.com...

    >
    > > > > I'm a AIX admin and the Oracle DBA and I have been working on an issue
    > > > > where Oracle seems to want all the RAM it can have.

    >
    > > > > Is it the case that Oracle Processes will take up as much RAM as
    > > > > possible? It seems everytime that Oracle Processes take up all the
    > > > > available RAM in our Production System. So everytime we add more RAM,
    > > > > it takes more up. Is this normal?There is something about Oracle 10 and AIX - oracle does it's own memory
    > > > management, so you need to do some funny things. I believe Oracle's site has
    > > > the required info.

    >
    > > > > What are other ORACLE/Unix shops doing to control RAM usage? How much
    > > > > physical RAM do you have in your servers? and how much does Oracle take
    > > > > up?Our AIX/Oracle server does pretty much nothing else, so yes, it uses all the
    > > > RAM, as indeed we want it to.

    >
    > > > cheers,
    > > > clive



  8. Re: AIX - Oracle Memory Issues

    Yeah same here John...pi's and po's stay at 0 all the time for us.

    If you were to do a svmon -G during a heavy Oracle usage time, is your
    "free" pretty low? And does your system page at all during those heavy
    crunch times?

    WOW 60 Oracle boxes all running AIX? I tip my hat off to you Sir!


    john.hoo...@gmail.com wrote:
    > pi's stay at 0, every now and again going up to 1,2,3, then back to
    > zero. po's stay at 0. Oracle 10G is pretty good at managing memory, and
    > if another process is needing it, it seems pretty good at giving a bit
    > up.
    >
    > Like Clive, our Oracle boxes are pretty much dedicated to only Oracle.
    > We have about 60 of them total running right now, mostly on F80s and
    > 6F1s on AIX 5.2, along with a couple 6H1s that were just updated to AIX
    > 5.3. Everything is being consolidated into the Integrity/Linux Oracle
    > cluster slowly but surely. I for one am wishing we had stayed with
    > pSeries/AIX rather than Integrity/Linux. AIX does a better job managing
    > memory than Linux does, but all in all, it works on both sides.
    >
    > On Jan 11, 5:42 pm, "dawaves" wrote:
    > > Thanks for those responses Clive and John.
    > >
    > > Do you guys have any paging going on? Like when you do a 'vmstat 1'
    > > command, are there any pi's and po's?
    > >
    > > I'm worried that if I let Oracle grab as much memory as possible, that
    > > at one point in the future, Oracle will grab all the RAM and
    > > subsequently, any new processes spawned will have to rely on the OS to
    > > Page from disk to free up RAM.
    > >
    > > Am I just being paranoid?
    > >
    > > Are there any others out there that have systems in which Oracle uses
    > > up as much RAM as possible?
    > >
    > > Thanks!
    > >
    > > john.hoo...@gmail.com wrote:
    > > > We are running pSeries 6H1s on AIX 5.3 and Oracle 10G. Oracle uses as
    > > > much ram as it can on these boxes. We also have some HP Integrity
    > > > systems in a RAC configuration, each of the four nodes has 24GB of RAM
    > > > and Oracle uses around 22GB right after boot, so I'd say it's normal
    > > > behavior.

    > >
    > > > On Jan 11, 12:23 pm, "Clive George" wrote:
    > > > > "dawaves" wrote in messagenews:1168538965.878371.103840@i56g2000hsf.g ooglegroups.com...

    > >
    > > > > > I'm a AIX admin and the Oracle DBA and I have been working on an issue
    > > > > > where Oracle seems to want all the RAM it can have.

    > >
    > > > > > Is it the case that Oracle Processes will take up as much RAM as
    > > > > > possible? It seems everytime that Oracle Processes take up all the
    > > > > > available RAM in our Production System. So everytime we add more RAM,
    > > > > > it takes more up. Is this normal?There is something about Oracle 10 and AIX - oracle does it's own memory
    > > > > management, so you need to do some funny things. I believe Oracle's site has
    > > > > the required info.

    > >
    > > > > > What are other ORACLE/Unix shops doing to control RAM usage? How much
    > > > > > physical RAM do you have in your servers? and how much does Oracle take
    > > > > > up?Our AIX/Oracle server does pretty much nothing else, so yes, it uses all the
    > > > > RAM, as indeed we want it to.

    > >
    > > > > cheers,
    > > > > clive



  9. Re: AIX - Oracle Memory Issues

    Free is around 2110, though it's tapering off for our real busy time of
    day and this is just on one (probably our most busy) server.

    At one point we had over 100 AIX/Oracle boxes, but as time has gone on,
    we've clustered things together, bought bigger machines that are able
    to handle 5-6 DBs each, etc. Once our RAC is up and running it will
    have around 150 Oracle instances on it... Impressive how far things
    have come in 5 years.

    On Jan 12, 11:59 am, "dawaves" wrote:
    > Yeah same here John...pi's and po's stay at 0 all the time for us.
    >
    > If you were to do a svmon -G during a heavy Oracle usage time, is your
    > "free" pretty low? And does your system page at all during those heavy
    > crunch times?
    >
    > WOW 60 Oracle boxes all running AIX? I tip my hat off to you Sir!
    >
    > john.hoo...@gmail.com wrote:
    > > pi's stay at 0, every now and again going up to 1,2,3, then back to
    > > zero. po's stay at 0. Oracle 10G is pretty good at managing memory, and
    > > if another process is needing it, it seems pretty good at giving a bit
    > > up.

    >
    > > Like Clive, our Oracle boxes are pretty much dedicated to only Oracle.
    > > We have about 60 of them total running right now, mostly on F80s and
    > > 6F1s on AIX 5.2, along with a couple 6H1s that were just updated to AIX
    > > 5.3. Everything is being consolidated into the Integrity/Linux Oracle
    > > cluster slowly but surely. I for one am wishing we had stayed with
    > > pSeries/AIX rather than Integrity/Linux. AIX does a better job managing
    > > memory than Linux does, but all in all, it works on both sides.

    >
    > > On Jan 11, 5:42 pm, "dawaves" wrote:
    > > > Thanks for those responses Clive and John.

    >
    > > > Do you guys have any paging going on? Like when you do a 'vmstat 1'
    > > > command, are there any pi's and po's?

    >
    > > > I'm worried that if I let Oracle grab as much memory as possible, that
    > > > at one point in the future, Oracle will grab all the RAM and
    > > > subsequently, any new processes spawned will have to rely on the OS to
    > > > Page from disk to free up RAM.

    >
    > > > Am I just being paranoid?

    >
    > > > Are there any others out there that have systems in which Oracle uses
    > > > up as much RAM as possible?

    >
    > > > Thanks!

    >
    > > > john.hoo...@gmail.com wrote:
    > > > > We are running pSeries 6H1s on AIX 5.3 and Oracle 10G. Oracle uses as
    > > > > much ram as it can on these boxes. We also have some HP Integrity
    > > > > systems in a RAC configuration, each of the four nodes has 24GB of RAM
    > > > > and Oracle uses around 22GB right after boot, so I'd say it's normal
    > > > > behavior.

    >
    > > > > On Jan 11, 12:23 pm, "Clive George" wrote:
    > > > > > "dawaves" wrote in messagenews:1168538965.878371.103840@i56g2000hsf.g ooglegroups.com...

    >
    > > > > > > I'm a AIX admin and the Oracle DBA and I have been working on an issue
    > > > > > > where Oracle seems to want all the RAM it can have.

    >
    > > > > > > Is it the case that Oracle Processes will take up as much RAM as
    > > > > > > possible? It seems everytime that Oracle Processes take up all the
    > > > > > > available RAM in our Production System. So everytime we add more RAM,
    > > > > > > it takes more up. Is this normal?There is something about Oracle 10 and AIX - oracle does it's own memory
    > > > > > management, so you need to do some funny things. I believe Oracle's site has
    > > > > > the required info.

    >
    > > > > > > What are other ORACLE/Unix shops doing to control RAM usage? How much
    > > > > > > physical RAM do you have in your servers? and how much does Oracle take
    > > > > > > up?Our AIX/Oracle server does pretty much nothing else, so yes, it uses all the
    > > > > > RAM, as indeed we want it to.

    >
    > > > > > cheers,
    > > > > > clive



+ Reply to Thread