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" <dawa...@xxxxxxxxx> 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...@xxxxxxxxx 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" <dawa...@xxxxxxxxx> 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...@xxxxxxxxx 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" <c...@xxxxxxxxxxxxxxxxxx> wrote:
"dawaves" <dawa...@xxxxxxxxx> wrote in messagenews:1168538965.878371.103840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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

.

Relevant Pages

  • Question: System File table is full
    ... I administer an Oracle 9 database which is hosted on an AIX 5.2.0.2 ... IBM AIX RISC System/6000 Error: 23: File table overflow Additional ... The system file table is full. ... as soon as I dropped one of the databases on the server, ...
    (comp.unix.aix)
  • Re: Slow connection to Oracle on AIX: using truss
    ... We are investigating slow connection to Oracle on AIX 5.2 ... using truss utility: ... "sar" does not show heavy load on the server. ...
    (comp.databases.oracle.server)
  • Slow connection to Oracle on AIX: using truss
    ... We are investigating slow connection to Oracle on AIX 5.2 ... using truss utility: ... "sar" does not show heavy load on the server. ...
    (comp.databases.oracle.server)
  • Re: Memory Question in Server 2003
    ... Enterprise = 8xCPU, 64GB RAM. ... Microsoft does not openly support this in Server 2003 Std. ... Oracle might, but they don't explicitly state this. ...
    (microsoft.public.windows.server.general)
  • Re: Significant virtual memory paging was detected on the host operating system
    ... Id' just setup a new server for our Database, ... Oracle 10.0.2.3 ... so, around 17GB for the instance, and it left 7GB of RAM for the OS ... I have trouble understanding why you need an 11 gig SGA. ...
    (comp.databases.oracle.server)