Re: Oracle Instance Stressing AIX and Solaris to the max

1. Fuentes wrote:

> 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,
>
> A. Fuentes

Based on what you've written I'd suggest pouring water on the server.

My point being that stress testing should relate to the intended usage. Do you expect in the real-world to have an artificially large SGA? Do you have any reason to believe you will even use rollback segments?

I'd suggest looking at your REAL application, tuning properly, and then ramping up the number of simultaneous users and transactions until they break.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)