Oracle set up

[jprabaker]

Hi,

I've got a p640 with 2 CPUs and 2Gb of RAM. We are running on Oracle 8.1.6 database on AIX 4.3.3 ML 09. The database is housed over 4 JFS's which are approx 70 Gb in size. Most the the oracle database files are around 2Gb in size.

My problem is that the system is using all of its real memory, but paging remains virtually untouched:

Memory Real Virtual
free 4 MB 2032 MB
procs 364 MB 15 MB
files 1678 MB
total 2048 MB 2048 MB

I've read that using "vmtune -P" can help if the system is accessing large files. I've tried "vmtune -P 95" which doesn't seem to have done a great deal.

Can anyone offer any suggestions or recommended reading?

Regards,

JP

 

[alexhu]

AIX always uses all of its real memory. It allows as much as the application wants, then uses the rest for filesystem caching.

If its not paging , sounds like you don't have a problem ;-)
Alex

 

[MikeLacey]

run 'vmstat 1' for a few minutes, if the po (page out) field remains zero, or mostly zero, then you don't have a memory problem Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.