Hi Guys: Would like to know how to check system swapping and paging and some theory on how they function. I am an oracle dba and my environment is 8171 on AIX 433. We have a 1GB of RAM on the box and I am educating myself to see how much more SGA can be accommodated on the box and what are the implications it can cause if swap/page happens.
Thanks, ST2000

Try this link from dbatoolbox.com - it explains tuning Oracle.

Note that on page 3 it states "When configuring memory fot the database first there must be an understanding of the memory at the server level"

You need to work WITH your sysadmin to get a system tuned for the application.

Thank You. I also have another question, how do you go a bout adding another second paging space of another 512 MB ?