Memory Testing

[sendilkumar]

Hi,
Can any one tell me how to do the memory testing with HP UNIX on Oracle DB. What are the parameters need to be checked and benchmark levels .IF any one has white papers on the same ,let me know.
thanks in advance

[skt_skt]

Could you elaborate a little more on "memory testing with HP UNIX on Oracle DB"

[sendilkumar]

i have web application which runs with HP UNIX on Oracle DB. I have created virtually 300 users and started running it concurrently. Now i need to check the memory useage of application.

[A. Clay Stephenson]

There are many ways; Glance is probably the best but you can always simply use "UNIX95=1 ps -e -o comm,pid,vsz. Regardless, the tricky part is trying to add the numbers up in some sensible manner. For example, most of your oracle client connections will have a great deal of text and library code that is shared. ie, there is but one copy of the code although each process will have a unique data segment. There is also shared memory to consider (ipcs -m will show those values). You should also be watching your swap usage (swapinfo -tam). Nothing will be as important as watching your page-out rate. You can use Glance of vmstat to determine the page-out rate. If you are paging out to any significant degree (po rates > ~ 15 for any length of time --- minutes at most) then you definitely need to scale back the size of the SGA and/or the number of processes and/or add more physical memory to the system. Swapping (paging out) is at least a 100x performance hit compared to anything else.