Hi Folks, I have just downloaded

[KOG]

Hi Folks,

I have just downloaded and ran nmon7 fileset on F50 to see how much mem we are using and was amazed by the response, it is not the kind of output I had expected !

nmon v7a Hostname=blbf50 Refresh=2.0secs 14:14.59
CPU Utilisation +-------------------------------------------------+
CPU User% Sys% Wait% Idle|0 |25 |50 |75 100|
0 0.0 0.0 0.0 100.0| > |
1 1.0 0.0 0.0 99.0| > |
+-------------------------------------------------+
0.2 0.0 0.0 99.8| > |
+-------------------------------------------------+
Memory Use Physical Virtual Paging pages/sec In Out VM parameters
% Used 99.0% 51.5% to Paging Space 0.0 0.0 numperm 55.1%
% Free 1.0% 48.5% to File System 0.0 0.0 minperm 19.9%
MB Used 1014.2MB 469.4MB Page Scans 0.0 maxperm 79.7%
MB Free 9.8MB 442.6MB Page Cycles 0.0 minfree 120
Total(MB) 1024.0MB 912.0MB Page Reclaim 0.0 maxfree 128


I have asked our hardware agency for a quote for 513 mem chip, would that help to improve the performance (as it does seem sluggish at times but only during v busy hours). Would another 512 mb be optimical or should I add another paging space too on rootvg?

Thanking you all in advance.

Regards

K

 

[bi]

It looks like more memory might help. Not so sure about paging space, though.

This is an Oracle database, right? My experience on sluggish performance of an Oracle database has always pointed to poorly laid out files (files not spread across disks and controllers properly). How are your files laid out? Are data and index on separate disks and controllers?

You also might go to the the IBM Redbooks page, search for tuning. You'll get a long list of books. The one you'll want is Database Performance Tuning on AIX. It has a good section on Oracle. Here's the link to Redbooks:

http://www.redbooks.ibm.com/

 

[KOG]

Hi Bi

Yes it is an oracle database, and I am in the progress of ordering a 1 gb memory plus new adapter for the server. The datafiles, index file and controllers are spreaded across three disks in the best way I can organised it. The problem is the company is v tight with budget and it is hard asking for more !

I had to show them the statistics of the nmon outputs to justify my point that we do need extra memory.

I will read the redbooks on performance issues.

Many thanks

Katherine

 

[bi]

You also might want to run topas (which is in /usr/bin) to see how busy your disks are. I've done some tests and the effect of file layout on the disks is significant.

 

[KOG]

Hi Bi

It is rather odd I do not have topas on /usr/bin, and I did complete installation of AIX 4.3.3.

Is there an extra fileset I should install, if so does it come out of the same installation disks or from web?

Cheers

K

 

[MoshiachNow]

HI,

Paging space should be normally bigger then the physicall.
The data above does not realy show the real busy picture ...
For paging space tips see :

http://www-1.ibm.com/support/docvie...ging&uid=aix119c4e641c3c694fd85256816006a0131

"Long live king Moshiach !"
h

http://www.noahide.com/movement.htm

 

[cspilman]

The fileset to install for 'topas' is:

bos.perf.tools
Regards,
Chuck