2010/2/4 van Sleeuwen, Berry :
> We have some oracle guests that have been set to 1G. And they actually
> need only 300M. The rest is occupied in cache (between 650 and 710M).
Be aware! The Oracle SGA lives in Linux page cache, together with
in-use programs and shared libraries. So on Oracle syst
Thanks Mark and to all that replied.
Guess I will have to build it myself.
The information contained in this e-mail message is intended only for the
personal and confidential use of the recipient(s) named above. This message may
be an attorney-client communication and/or work product and as suc
O, I didn't know that. I'd expected the reported linux cache to be
filesystem cache and as such not directly related to oracle.
Berry.
-Original Message-
Be aware! The Oracle SGA lives in Linux page cache, together with in-use
programs and shared libraries. So on Oracle systems it is nor
I realize that it would not be a apples to apples comparison, but is there
a similar discussion about sizing guests that are running DB2? With STMM
on? And the "Be ware!"s? Does DB2 have instrumentation that can tell you
how it's using memory and indicate "good" value. I am aware the STMM is
suppos
On Fri, Feb 5, 2010 at 4:26 PM, Sterling James wrote:
> I realize that it would not be a apples to apples comparison, but is there
> a similar discussion about sizing guests that are running DB2? With STMM
> on? And the "Be ware!"s? Does DB2 have instrumentation that can tell you
> how it's using
Thanks for the comments.
> to set DB2 memory management to "automatic" to let it size itself based
on the Linux configuration.
Which can be interpreted as, with STMM set (fully) on, DB2 will try to use
85% of configured memory (if it needs it ofr not). Then it's back to
guessing how much is really
Another handy item for Oracle folks is:
http://www.oracle.com/technology/software/tech/orion/index.html
Allows you to simulate Oracle I/O loads on disk configurations without
actually having to install Oracle and find a database big enough to stress
test your filesystem configuration and get your
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all:
I'm doing some comparison studies on dasd / disk I/O for different
configurations of storage and storage on different virtualization
platforms (trying to convince management that oracle on Z is an okay
thing). I'd really really appreciate an
>>> On 2/5/2010 at 07:04 PM, Patrick Spinler wrote:
> I'd plan to do all this testing on an up to date install of rhel 5.4 in
> a single IFL guest, ...
Comparing the performance of one instance of Linux for System z to one instance
of anything else is likely going to make the System z look anem
On 2/5/10 7:04 PM, "Patrick Spinler" wrote:
> I'm doing some comparison studies on dasd / disk I/O for different
> configurations of storage and storage on different virtualization
> platforms (trying to convince management that oracle on Z is an okay
> thing). I'd really really appreciate any
Hello Patrick,
I don't have a lot of Oracle DB experience, but our acquisition had it up with
a prod app. They found Oracle behaved much better with 2 vcpus. It wasn't
even using 1/3 of a single z9 IFL at peak, but with 2 vcpus it flew compared to
1. The theory was that Oracle must have writ
11 matches
Mail list logo