Thanks, John. No there's no paging/swapping going on (1GB real memory for a single 200MB SGA and just a couple of users).
Out of curiousity, John. I usually measure paging via vmstat (si/so columns on Linux and pi/po everywhere else - "everywhere else" being HP-UX, Solaris and AIX), as well as via sar -w (swpin/s, swpot/s) on HP-UX/Solaris and sar -W on Linux (pswpin/s, pswpot/s). Is sar -r a better way? Quick check shows that on Linux it seems to report memory and swap utilization (but not in terms of rates, rather absolute numbers). On HP-UX it doesn't seem to be covered by man pages, but effectively the output is the same as -w. On Solaris it shows "unused memory pages and disk blocks". And I don't currently have any IBM boxes around As for the wrong bucket... well, I'll be able to verify it in the next couple of weeks on Solaris and for sure on HP-UX. One thing I know is that both vmstat and sar -u agree here on Mandrake that it is the kernel-mode that chews up most of the CPU for this 3-4 sec snapshot time. Thanks, Boris Dali. --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > Boris, > > I missed the second part of your question... > apologies. If your SGA/Shared > pool was partly swapped out, I would assume that you > might see an increased > 'system' utilization. Did you check 'sar -q' and > 'sar -r' at the same time > to check? I haven't used mandrake - just wondering > if the CPU cycles used > for memory access are being counted against the > wrong pigeonhole.. > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Grace - Getting something we don't deserve; Mercy - > NOT getting something we > deserve > Click on 'http://www.needhim.org' for Grace and > Mercy that is freely > available! > > ** The opinions and statements above are entirely my > own and not those of my > employer or clients ** ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
