Oracle Instance Stressing AIX and Solaris to the max

From: A. Fuentes <alvarofuentes_at_austin.rr.com>
Date: Mon, 27 Dec 2004 03:02:36 GMT
Message-ID: <gXKzd.7592$3v5.4607@fe2.texas.rr.com>

Fellow Oracle Users:

We need to test Oracle stressing 1)AIX and 2)Solaris to the MAX. What would be a good strategies to make Oracle to stress Solaris and AIX?

1)Defining very big SGA's, bigger than the actual swap and RAM, so to induce high rates of paging?

2)Creating Very small rollback segments (very few extents) so that very frequent "wrapping" happens?

What would be the most important Oracle parameters (init.ora, etc) to modify, in
order to induce a maximum of CPU usage?

Any ideas will be greatly appreciated.

Cheers,

Received on Sun Dec 26 2004 - 21:02:36 CST