For example:

vmo -p -o minperm%=3
vmo -p -o maxperm%=90
vmo -p -o maxclient%=90
vmo -p -o lru_file_repage=0
vmo -p -o strict_maxclient=1
vmo -p -o strict_maxperm=0

	As documented in the IBM "VMM Tuning Tip" referenced below, if you are running on AIX 5.2 ML04 or higher, or AIX 5.3 ML01 or higher, IBM is now recommending the following VMM settings for use with programs which need to protect computational memory (like Oracle):



	strict_maxperm=0 (default)

strict_maxclient=1 (default)

lru_file_repage=0

maxperm%=90

minperm%=5 (physical RAM <32 GB)

minperm%=10 (physical RAM >32 GB but <64 GB)
minperm%=20 (physical RAM >64 GB)

v_pinshm=1

maxpin%=percent_of_real_memory



	





	(IBM does not recommend decreasing the maxpin% value.  See the "Support for pinned memory" link in the References section below.)

Where "percent_of_real_memory" = ( (size of SGA / size of physical memory) *100) + 3
and
Set Oracle database parameter LOCK_SGA to TRUE in the pfile/spfile
and
Sum of all SGAs on the system do not exceed approximately 60% of physical memory



	
	

		
		

			
			

				AIX: Database performance gets slower the longer the database is running (文档 ID 316533.1)