Of course, there are a lot of things to look at. I think what you're looking for is svmon -U username. This will show you the user's memory map. Svmon with no arguments shows you overall stats; one thing to look for there is that there should be no pinned memory for UV; Oracle needs pinned memory, it's wasted with (and unusable to) UV.
Further, there are three AIX commands that will display environment variables (as of 5.2) are vmo, ioo, and schedo. Vmo -l, for example, will give you virtual memory settings. These are stored in /etc/tunables/lastboot, but - similar to looking at uvconfig rather than analyze.shm - what's in lastboot may not be the current values. Now, one of the first things to look at is in vmstat -v. This is output in nmon, if you're running that daily (recommended); if not, you can run it at the command line. Look for these lines: vmstat -v 0 pending disk I/Os blocked with no pbuf vmstat -v 0 paging space I/Os blocked with no psbuf vmstat -v 9877 filesystem I/Os blocked with no fsbuf vmstat -v 0 client filesystem I/Os blocked with no fsbuf vmstat -v 0 external pager filesystem I/Os blocked with no fsbuf If, over time, these are growing, you'll need to increase the number of the various file buffers. If you see growth over, say, an hour, you'll want to increase significantly. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of ericro Sent: Wednesday, March 04, 2009 1:59 PM To: [email protected] Subject: [U2] Performance monitoring We run an IBM P570 with 12 processors running Universe 10.2.4, average of 400 users against at EMC DMX4500 disk array. 20 file systems with each about 45gb, 60-80% utilized striped across 94 disks. We do tons of batch processing at night and our rate of data change is about 175GB an hour at night. We're running into some performance issues, jobs taking much longer, keyboard response slow, editing single records taking a long time, etc. and want to really dive in to see what's going on. We've looked at file sizing and have done a fair amount of resizing, but to little avail. Does anyone have any tools, or know of any tools, similar to Oracle, that can really give me insight into what's happening with a given user session at any time? I know I can do port.status and find the address in the code and see what's being executed at that time, but I want something more that will show memory utilization and other stats like that. Any help would be appreciated. -- View this message in context: http://www.nabble.com/Performance-monitoring-tp22336819p22336819.html Sent from the U2 - Users mailing list archive at Nabble.com. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
