We have a problem in that we run Oracle and Sybase on the same box
with supposedly 3GB of physical memory, although using the AIX monitor
commands only cites about 2.5GB. The shared pool for Oracle was about
1 G, and the equivalent memory structures for Sybase were about 1.5GB.
(effectively using the entire physical memory). There are about 6GB of
paged
memory, but we're getting a lot of swapping lately. I reduced the
block buffers
by about 1/4, (which in my case frees up 400MB), in hopes that the users
wouldn't be affected, but my question is about binding. Someone
suggested that
we bind Sybase processes to either CPU's or particular memory areas,
and/or
do the same thing with Oracle. Recently, we had an important job fail
we believe
due to the shortage of memory. Does anyone have any experience binding
to
either CPU and / or memory with 2 disparate databases on the system? We
have
another person on the account who is firmly against it, think the OS
should do it's
thing. (Clearly, buying more memory would be nice..but not currently an
option).
We are running on AIX 4.3 with Oracle 8.0.5 and Sybase 11.x something.
Received on Thu Aug 05 1999 - 13:14:25 CDT
